Exporting Data to XML

HTML has one major limitation: It in no way separates data from the presentation of data. XML's main objective is to separate data and its structure from the presentation of the data. Furthermore, it provides a universal data format that can be read by a multitude of machines on a multitude of operating systems and platforms. It bridges the gap between the variety of systems that store data in a variety of disparate formats. Access makes it easy for you to export data to XML. To export an object to an XML file, follow these steps:

  1. Right-click the object you want to export and select Export from the context menu. The Export dialog box appears.

  2. From the Save As Type drop-down box, select XML.

  3. Select the folder where you want Access to save the XML file and click Export. The Export XML dialog box appears (see Figure 19.9).

    Figure 19.9. Designating what XML-related documents to create.


  4. Select what to export: the data, the schema of the data, the presentation of the data, or any combination of the three.

  5. Click the More Options button to designate additional options.

  6. Click OK to create the XML document. If you selected the Presentation of Your Data option in step 4 and you view the XML document in a browser, it looks as shown in Figure 19.10.

    Figure 19.10. An XML document viewed in a browser after the Presentation of Your Data option is selected.


    Part III: Creating Your Own Database and Objects
    Part V: Advanced Topics