Chapter 12. Access databases and XML Office Power User Task

  • Exporting Access tables as XML

  • Transforming exported data

  • Importing XML data to Access

This chapter covers the XML features of Microsoft Access, specifically the tasks of importing and exporting XML. These features allow Access databases to be integrated into XML workflows with other enterprise systems.

Skills required

Skills required

Experience using Microsoft Access to create and query databases. To use transforms, you’ll need to know about XSLT (see Chapter 18, “XSL Transformations (XSLT)”, on page 392).

Why use XML with Access?

The XML features of Microsoft Access consist of an export and import process. ...

Get XML in Office 2003: Information Sharing with Desktop XML now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.