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

Chapter 28. Working with XML and SharePoint > Using XML in Microsoft Access

Using XML in Microsoft Access

Although Microsoft Access 2002 introduced the ability to export and import XML files, it could handle only limited XML features and could not import or export a multiple-table schema. Access 2003 not only allows you to import and export data from multiple, related tables, it also supports the exporting of forms and reports that look similar to the original object in your Access application. The new smart tag feature that you see sprinkled throughout Access 2003 also depends on XML technology.


Exporting and Importing XML from the User Interface

From the Database window of any Access desktop database (.mdb) or project file (.adp), you can export any table, query (view, function, or stored procedure in a project file), form, or report by selecting the object in the Database window and then choosing Export from the File menu. You can also import any XML file as a table by choosing Get External Data on the File menu and then choosing Import on the submenu. The following sections show you how to perform these actions.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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