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