Convert Access data to XML format

access|xml| Data | conversion

Q: How can I convert data from a Microsoft Access data table to XML format?

A: The following applications can help you convert access data to XML format: Access 2002, ADO 2.5, and SQLXML. You can query for data from Access 2002 (part of Microsoft Office XP) or save data in XML format. You may want to automate this conversion process. ADO 2.5 and subsequent versions allow you to open data to a recordset, and then hold the recordset in XML format, as shown in the following code:

Rs. Save "C:\rs.xml", adPersistXML
You can also use a linked server to add an Access database to a SQL Server 2000 database to run queries and retrieve data from within SQL Server. Finally, you can extract the required access data in XML format using HTTP and SQLXML technology.