Exporting XML from Access 2003

Compared to its more recent version, Access 2003 is a jungle. For all of your internet database displaying needs, Jayaram Krishnaswamy is here:

“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.”

Read the full article hosted by Aspfree with pictures and explanations included.