Section 12.1. Why use XML with Access?

Prev	don't be afraid of buying books	Next

12.1. Why use XML with Access?

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

12.1.1 The export process

XML can be generated from any Access tables, queries or forms. Doing so makes the data available for a variety of processes, such as:

• Reporting on the data in a Web page or Word document;

• Sending the data to a business partner as part of an e-commerce transaction;

• Analyzing the data in Excel; and

• Importing the data into a different database for business integration, reporting, and/or backup.

12.1.2 The import process

XML can be imported into Access tables. This is one way to interface the Access database with other applications, such as an e-commerce application that transmits orders as XML documents. It is also a means of populating Access tables when they are initially created.

	Amazon