Microsoft® Office Excel 2003 Programming Inside Out

Chapter 23. Introducing ADO

The ADO Object Model

The Connection Object

The Command Object

The Recordset Object

ActiveX Data Objects (ADO) lets you use Excel VBA to access a database. ADO relies on a Data Provider/Data Consumer model. (See Figure 23-1.) This model is similar in concept to the client/server model, except that the client/server model generally assumes that your database operates as an independent server. This restriction doesn’t apply to ADO.

Figure 23-1. A data consumer makes requests to a data provider, which returns a response about the request to the data consumer.

Instead, ADO requires only that the data provider supply data ...