Sample Code

[Bill Putnam]

I need to take some MDB files, and use VB/ADO to open
them then store the data in XML files. I do not want
to re-invent the wheel. Any specific sample code or
URLs to web sites that would cover this?

[Phil Pastor]

Bill Putnam wrote in message <38dbb815$1@news.devx.com>...
>
>I need to take some MDB files, and use VB/ADO to open
>them then store the data in XML files. I do not want
>to re-invent the wheel. Any specific sample code or
>URLs to web sites that would cover this?

Following is copied from an earlier post. (I hope that's OK, David)

I thought that the easiest way to write an XML file is by using the
recordset
save method:

Dim file_name as string
file_name = "c:\xml\xml_tst.xml"
Dim rs as recordset
'--establish connection
'--open the recordset

Rs.save "file_name", adPersistXML


And the XML file is created with no other work. This requires ADO 2.5

David