Export Data from ADO Recordsets to XML

Category:
ASP, HTML and XML
Type:
Classes
Difficulty:
Intermediate
Author:
Intelligent Solutions Inc.

Version Compatibility:

More information:
This class allows you to convert data from ADO recordsets to XML and save it to a file. Support for adding the complete recordset, recordset rows, and individual field values is provided. Unlike the XML support included with ADO 2.5, this class does not write extended schema information to the XML file. Detailed documentation is included.

If you'd like to do this using ADO 2.5, see http://www.freevbcode.com/ShowCode.Asp?ID=1204. The advantage of using ADO is that you will be able to load the saved XML file back into a recordset object.


Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download xmlexport.zip