Microsoft Office Tutorials and References
In Depth Information
Exporting XML Data
When you export a table as XML data in Access 2003, you’ve got a number of
options to use to control the type of output produced. Begin the export by
right-clicking the table in the Database window; then choose XML in the Files
of type list. The Export XML dialog box enables you to choose whether you
want to export data only, the schema only, or the presentation of the data.
If you want to further control the output, you can click More Options to
display additional choices for the output of the XML, XSD, and XSL files.
Tip When you export forms and reports, Access generates the
output file using an XML-based language called ReportML. When you
generate tables, queries, and datasheets, the output resembles a
This chapter has provided a first look at the far-reaching XML support features
incorporated into Office 2003. The integration of XML makes Office 2003 more
flexible, more powerful, and more adaptable to enterprise-wise applications
than ever before. Although this chapter has spotlighted a number of the key
XML additions in Word, Excel, and Access, you’ll get a much better feel for the
seamless application and easy functionality of XML in Office 2003 when you try
it for yourself. Whether you’re an end user, a decision-maker, or a developer,
you’ll want to learn more about this highly flexible and widely accepted new
standard for data exchange, publication, and storage.