Chapter 37. Using XML in Access 2007
IN THIS CHAPTER
Reviewing a primer on XML
Working with HTML and XML
Looking at the dynamic object model
Working with XSL and XSLT
Sharing XML and RSS
Looking at Access 2007, XML, and DAO
Over the past several years, XML has grown in importance as a data storage format, as well as a reliable technology for sharing data among multiple applications. XML is a native data format recognized by all of the Microsoft Office 2007 applications. XML is the technology wave of the future in the computer industry. Earlier in this book you saw how easy it is to link to XML files and how to seamlessly import XML data into an Access 2007 application.
This chapter continues the discussion on XML by explaining XML and using XML in some detail. Also, this chapter includes a significant amount of VBA code demonstrating how to automate XML data import into Access applications. Earlier chapters explained the manual, interactive processes of linking, importing, and exporting XML data, but this chapter shows you how to automate some of these operations with VBA code.
This chapter uses the database named
Chapter37.accdb on the book's CD. If you haven't already copied the file onto your machine from the CD, you'll need to do so now.
Introducing HTML and XML
Getting an introduction, however brief, to HTML, XML, and XSL is important. These terms are easily confused, and taking the time now to get acquainted with the terminology used when working with XML data sources is well spent. ...