Importing, exporting XML file to ADO recordset - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Importing, exporting XML file to ADO recordset

I seem to have some problems with the XML support of ADO
2.6. It's very easy to export a recordset to an xml file.
With : rsXMLtest.Save "C:XMLtest.xml", adPersistXML
Where: Dim rsXMLtest As ADODB.Recordset
This works very nicely. However when I try to load the xml
file into a recordset with:

rsXMLimport.Open "C:XMLtest.xml", "Provider=MSPersist;",
adOpenStatic, adLockBatchOptimistic, adCmdFile

This also works as long as fields of character strings are
empty. If there is data in a stringformat field I get the
following error message:

"Multiple-step operation generated errors. Check each
status value."

I'm desperately trying to solve this problem, but I can't
find any information regarding this issue.

Can anybody please help me?

Sign In or Register to comment.