Converting Access Data into XML

Microsoft’s SQL Server development team tells you how three applications can help you convert data in an Access table into XML.

1 Min Read
ITPro Today logo

How can I convert data in a Microsoft Access table into XML format?

The following applications can help you convert Access data into XML format: Access 2002, ADO 2.5, and SQL Server 2000's SQLXML. Access 2002 (part of Microsoft Office XP) lets you save a table or query in XML format. You might be able to automate this process. ADO 2.5+ lets you open the data into a recordset, then persist the recordset in XML format, as the following line of code shows:

rs.Save "c:rs.xml", adPersistXML

And SQL Server 2000 lets you use linked servers to add the Access database so that you can run queries from within SQL Server to retrieve data in that database. Then, you can use the SQLXML technology to extract through HTTP the Access data in the XML format you want.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like