Microsoft Office Tutorials and References
In Depth Information
Exporting an Access Table as an XML File
Belmont Landscapes uses an accounting package that accepts the data in XML files as
input for making accounting entries. Sarah wants to test this capability by exporting the
tblInvoice table as an XML file and giving the XML file to the company’s accounting
manager for testing with the accounting package.
Reference Window | Exporting an Access Table as an XML File
• Right-click the object (table, query, form, or report) in the Navigation Pane, point to
Export, and then click XML File.
• Click the object (table, query, form, or report) in the Navigation Pane. In the Export
group on the External Data tab, click the More button, and then click XML File.
• Click the Browse button in the Export - XML File dialog box, navigate to the location
where you will save the XML file, and then click the Save button.
• Click the OK button in the dialog box, select the options in the Export XML dialog box or
click the More Options button and select the options in the expanded Export XML dialog
box, and then click the OK button.
• Click the Close button.
• If you need to save the export steps, click the Save export steps check box, enter a name
for the saved steps in the Save as text box, and then click the Save Export button.
Importing and Exporting Data
You’ve imported data from an Excel workbook and a text file (TXT extension) in Tutorial 2
and from a text file (CSV extension) and an XML file in this tutorial. Additional Access
options include importing an object from another Access database, importing data from
other databases (ODBC databases such as SQL Server, dBASE, and Paradox), and importing
a Lotus 1-2-3 file, an HTML document, an Outlook folder, or a SharePoint list.
In addition to exporting Access objects as an XML file or an HTML document, Access
includes options for exporting data to another Access database, other databases (ODBC
database, dBASE, or Paradox), an Excel workbook, a Lotus 1-2-3 file, a text file, a Word
document, or a SharePoint list. You can also “export” table or query data to Word’s mail
merge feature, or export a report to a snapshot file (SNP extension) so you can view it with
the Microsoft Snapshot Viewer available from the Microsoft Download Center.
Also available from the Microsoft Download Center is the Microsoft Save as PDF or XPS
add-in that you can download and install to export and save objects as PDF or XPS files.
Installing this download adds a “PDF or XPS” button in the Export group on the External
Data tab. PDF (Portable Document Format) and XPS (XML Paper Specification) are file for-
mats that render reports and other objects in a form viewable on any computer using the
free Adobe Reader program for PDF files and an XPS reader program, such as Windows Pre-
sentation Foundation, for XPS files.
The steps you follow for all import and export options work similar to the import and export
steps you’ve used in this tutorial and in Tutorial 2. For example, to save an object as an XPS
file, right-click the name of the object you want to export in the Navigation Pane, point to
Export on the shortcut menu, click PDF or XPS, navigate to the folder where you want to
store the file, click the Save as type arrow, click XPS Document, click the Publish button,
and then click the Close button.