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

Chapter 23. Exporting and Importing Data... > Adopting XML as a Data Interchange F...

Adopting XML as a Data Interchange Format

Microsoft’s primary selling point for Office 2003 is the capability of Word, Excel, and Access to export and import documents and data in Extensible Markup Language (XML) 1.0. Structured documents and relational data stored as XML files can be exchanged between multiple business applications running under different operating systems. Interchangeability is the driving force behind the wide-spread adoption of XML as the 21st-century standard for sharing information.


Microsoft’s stated goal for Office 2003 is to make XML an “open standards” alternative to proprietary Microsoft file formats. For example, Access can import structured XML documents—such as resumes, employee performance review, or expense reports—prepared in Word 2003 to relational data stored in a Jet or SQL Server database. The key to the document import process is a consistent document structure that’s defined by a schema. (The next section defines XML schemas). Access interprets the schema to determine the tables and fields in which to store the data contained in the document’s elements. The same schema supports exporting the documents back to Word.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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