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

Chapter 24. 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 2002 and SQL Server 2000. Access 2002 also can import well-formed, attribute-centric XML data documents to new tables or append data to existing tables. Access's XML import feature is limited to XML files that have elements from a single table or query. If you want to import order and line-item data, for example, you need an XML data document for each table. To maintain referential integrity, you append the orders document and then the line items document.

The capability to import XML to Jet and SQL Server tables will become increasingly important as Microsoft and other software publishers—as well as many businesses—move to XML as the preferred method of interchanging data. Microsoft's “HailStorm” initiative, announced in Spring 2001, is an example of a framework for transferring XML data in an instant-messaging environment. Most new Internet-based technologies introduced in 2001 and thereafter will use XML to exchange data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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