• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Exporting Data to XML

Access makes it easy for you to export data to XML. To export an object to an XML file:

1.
Right-click the object that you want to export, and select Export.

2.
Select XML Documents from the Save As Type drop-down box.

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

Figure 21.2. The Export XML dialog box allows you to designate what XML-related documents you want to create.


4.
Select whether you want to export the data, the schema of the data, the presentation of the data, or any combination of the three. The sections that follow discuss the schema (XSD) and presentation (XSLT) files.

5.
Click the Advanced button to designate additional options.

6.
Click OK to create the XML document. Viewed in a browser, after you select the Presentation of Your Data option, the XML document appears as in Figure 21.3.

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



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint