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

Chapter 23. Exporting and Importing Data... > Importing XML Data to Tables

Importing XML Data to Tables

Most of this chapter is devoted to exporting XML documents from Access 2003 and SQL Server 2000. Access 2003 also can import well-formed, element-centric XML data documents to new tables or append data to existing tables. Access’s 2002’s XML import feature was limited to XML files having elements from a single table or query. If you wanted to import order and line item data, for example, you needed an XML data document for each table. To maintain referential integrity, you had to append the orders document and then the line items document in separate operations.

Access 2003’s new import XML dialog lets you import data to multiple tables from a single XML document and its XML schema. If you don’t have an .xsd file for the document, Access 2003 infers the structure of the document and can create a schema for it. Another new Access 2003 XML feature is the capability to create empty related tables from an XML schema (.xsd) document. You also can transform the XML data during import with custom .xsl files.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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