Exporting XML from MS Access 2003
(Page 1 of 4 )
In a related article on importing into MS Access 2003 from an external source using its built-in support for such an activity, we fell short of a complete success unless some styling/schema information could be supplied. This tutorial looks at the reverse process, namely exporting data from MS Access into XML format.
This article is about exporting XML data from MS Access 2003. XML is the lingua franca of the Internet and is used extensively in how we communicate. XML is ubiquitous and will become more so with time. The extensibility, the essentially text-based format, and the ability to carry the data in its body make it unique, and extremely useful in how information is disseminated.
MS Access has gone through many revisions, and over time it has added support for importing and exporting its data into HTML as well as XML. One look at the source view of the Data Access Pages, a new object to display data on the intranet which appeared in version 2000 and above, reveals how deeply these different formats have penetrated the product. According to the product document, MS Access 2003 fully supports importing and exporting XML. In addition to the built-in support explored in this article, and the previous one dealing with importing, one could also use scripting support to explore this functionality in MS Access 2003. But this is not considered in this tutorial.
Exporting a single table from MS Access
The exported table
A new table named Argentina was constructed from the Orders table in the Northwind example database. This is a table that shows all orders originating from Argentina. The contents of this table are shown in the next picture.
The next picture shows the design view of the table. It has only four fields.
-->