Doug,

>I have been provided a hierarchical XML file created by Chase Insurance using XMLSpy. They have changed from a previous NAILBA file format. We now need to import data from the XML file - but have had no luck using XMLTOCURSOR (didn't import all data) or XMLAdapter (errors encountered). Can it be imported directly into SQL Server or VFP? Our preference would be to import into a VFP cursor, but we are at the point where importing into anything is better than nothing. Thanks for any help you can provide.

As you found out, XMLTOCURSOR cannot handle hierarchical XML structures. XMLAdapter can in most cases, but not necessarily automatically without a few "tweaks."

Does your XML have an inline schema section at the top or an external XSD schema file? What is the error you get from XMLAdapter (maybe "Schema too complex"?)

If you email me the XML and schema (if you have one) I'll take a look tonight and let you know what to do so XMLAdapter can handle it.