O'Reilly logo

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required