Access™ 2007 Bible

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.

Note

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. ...