Search notes:

ADO

ActiveX Data Objects (ADO) $ ADO

ADO is one of the primary MDAC technologies (the two others being OLE DB and ODBC). In fact, in order to use ADO, MDAC needs to be installed.

ADO is a wrapper around OLE DB that privdes a consistent interface to the (various) OLE DB providers. Thus, ADO is used by client applications to access and manipulate data from various sources through OLE-DB.

Although conceptually, ADO is not tied to OLE-DB, the only engine that supports the ADO model is OLE-DB.

Adding reference to VBA project

A reference to the ADO library (Microsoft ActiveX Data Objects 6.1 Library) in an Excel VBA project can be made in the immediate window:

call thisWorkbook.VBProject.references.addFromGuid("{B691E011-1797-432E-907A-4D8C69339129}", 6, 1)

ADO Object Model

The ADO Object Model consists of eight objects (as of ADO 2.5):

Connection	Represents a connection to an OLE-DB datasource
Error	Details about errors encountered
Command	An action (typically: an SQL statement) to be executed on the data source
Parameter
Parameters	An optional set of parameters for the `command` object
Recordset	A set of records
Field	A column in a Recordset (in a Record?)
Property
Stream	Read/write binary data
Record	A row in a Recordset, directory or file

ADO/R (which is used with the Advanced Data Connector) is a subset that consists of the Recordset and Field objects only.

Remote Data Service (RDS)

RDS is a feature of ADO that copies data to a client for manipulation and then updates the data on the server when done with it.

RDS is deprecated in favor of WCF Data Service and will be removed from future Windows versions.

ADO Multidimensional (ADO MD)

ADO MD is used for working with multidimensional data.

ADO 6.0

ADO 6.0 is included in Windows Vista as part of the Windows Data Access Components (Windows DAC) 6.0.

ADO 6.0 is functionally equivalent to ADO 2.8.

ADO

Adding reference to VBA project

ADO Object Model

Remote Data Service (RDS)

ADO Multidimensional (ADO MD)

ADO 6.0

See also