• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

18. XML > 18.4. Export XML

18.4. Export XML

Problem

You need to export Access data to an XML file so that it can be used in another application.

Solution

There are several different approaches to exporting XML data from Access, depending on the results that you want. The 18-04.MDB sample database has three tables, Car, Customer, and Preferences. The Car and Customer tables contain information about cars and customers, and the Preferences table contains information about which cars a customer prefers. The Preferences table is related to both the Car and Customer tables.

Exporting all of the data in related tables

If you wish to export all of the data in related tables, you can do so easily from the File menu. Follow these steps to export data as XML from the Preferences table:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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