Programming Excel with VBA and .NET

ADO Objects and Members

The ADO object model includes the key objects listed in the following table. There are additional objects, but these cover the fundamentals of working with ADO. For information about the additional objects, see the ADO Help.

Object	Description
Command	Defines a specific command—such as a SQL statement, table name, or stored procedure—that returns data from a data source.
Connection	Represents a connection to a data source.
Field	Represents a field of data from a data source.
Parameter	Represents a parameter associated with a specific command.
Record	Represents a single record in a recordset.
Recordset	Represents a set of records from a table or command.

Descriptions of the members of these objects follow. Key members (shown in bold) are covered in the following reference sections.