You may want to use XMLAdapter with a schema. XMLTOCURSOR is very limited. I tried this with the XML documents from some insurance companies that I need to deal with, and it didn't work well. Then I changed to XMLAdapter. It seems to work okay, though I'm posting a question here now.

>We have a system that currently imports a NAILBA (2.1) text file of insurance data to update our policy information. The insurance company is now switching to the ACORD standard which uses an XML format. I have tried testing the file they sent using XMLTOCURSOR() and am not having much luck. I am using the following code:
>
>xfile = 'xmlSample.xml'
>xstring = FILETOSTR(xfile)
>XMLTOCURSOR(xstring,'sample')
>
>It doesn't look like all the data is being imported - I can view the XML file and I don't see all of the data in the VFP cursor. Is anyone familiar with working with ACORD? Or anyone have any better ways to import the XML file?
>
>Thanks,
>Doug