Welcome to the new platform of Programmers 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 it's 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
I'm desperately trying to solve this problem, but I can't
find any information regarding this issue.
Can anybody please help me?