Special Edition Using Microsoft® Office Access 2003

Chapter 23. Exporting and Importing Data with XML

In this chapter

• Adopting XML as a Data Interchange Format

• Gaining an XML Vocabulary

• Moving from Access to XML-Based Web Front Ends

• Exporting Tables and Queries to XML and HTML

• Reformatting HTML Tables and Adding Page Elements

• Deploying Exported XML File Sets to a Web Server

• Exporting Static Reports as XML

• Exporting Live Web Reports

• Using SQL Server 2000’s HTTP Query Features

• Setting Up IIS 5.0 and SQL Server 2000 for Web Access

• Importing XML Data to Tables

• Exporting and Importing Data in Related Tables

• Applying Custom XSL Transforms to XML Data

• Troubleshooting

• In the Real World—Why Learn XML?

Adopting XML as a Data Interchange Format

Microsoft’s stated goal for Office 2003 is to make XML an “open standards” alternative ...