Howdy, Stranger!

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


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?


  • Chris BrownChris Brown USAMember Posts: 4,624 ✭✭

    ______ / / free ebooks and video tutorials about || Objective-C C# PHP R Java C MATLAB JavaScript C++ Visual Basic Python PL/SQL Delphi Assembly Visual Basic .NET Go Scratch Swift Perl Ruby Crystal Hack Fortran Transact-SQL Julia Alice F# Scheme Awk Prolog Logo Lisp FoxPro LabVIEW Rust SAS ABAP Kotlin COBOL Scala Clojure Lua Erlang D VBScript Apex Bash Dart Ada ML || ______

Sign In or Register to comment.