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?