from office.microsoft.com

Exporting to XML from Access\tHelp
Assistance > Access 2003 > Working with Data > External Data

Show AllShow All
Hide AllHide All
Applies to
Microsoft Office Access 2003
Microsoft Access 2002

In Access 2002 or later, you can output data to Extensible Markup Language (XML) by exporting to an XML document. You can also output schema files to specific the structure of the XML document as well as a style sheet to describe the presentation of your data.

HideExport a table, query, form, or report as XML

1. In the Database window, click the name of the table, query, form, or report that you want to export, and then on the File menu, click Export.
2. In the Save as type box, click XML Documents (*.xml).
3. Click the arrow to the right of the Save in box, and select the drive or folder to export to.
4. In the File name box, enter a name for the file, and then click Export.
5. In the Export XML dialog box, do one or more of the following:
* To export the data to an XML document, select Data (XML).
* To export the schema to an XML file, select Schema of the data.
* To format your table or query data by using an Extensible Style Language file, select Presentation of your data (XSL).

Note The Data check box must be selected for the Presentation of your data (XSL) drop-down box to be available.
6. Click OK to export to the XML document.

ShowSet advanced options for exporting XML files