Working with the Data Access Components of an Office Solution

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

The primary role of many Microsoft Office solutions is to turn raw data into usable information. This can entail managing data from a broad variety of sources, including data stored in Office applications, such as Microsoft Access databases, Microsoft Excel workbooks, or Microsoft Outlook folders, as well as in other sources, such as Microsoft SQL Server databases, HTML tables, dBASE files, Lotus 1-2-3 spreadsheets, or tabular text files. This chapter describes the data access technologies supported by Office applications, and provides an introduction to using ActiveX Database Objects (ADO) code to work with your data.

Contents

Microsoft Office Data Access Technologies

ADO Basics

Using ADO to Work with Access Databases

Where to Go from Here