I gave up on using XMLTOCURSOR and XMLAdapter for my data feeds. I parse out the files using Microsoft.XMLDOM and create cursor. It was a pain to setup but works well now.

If they are using Acord standards you may want to look at: http://www.pilotfishtechnology.com/download.htm

They have a free product that will take Acord XML files and get them into Access or MSSQL.




>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.
>
>Doug