Microsoft Office 2000/Visual Basic Programmer's Guide

Working with the Data Access Components of an Office Solution

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