ADO Basics:
ADO stands for
Active Data Object and is a set of objects and their properties and methods.
They are used for describing and manipulating data between a database and your
VBA program.
ADO can be used with
Access, Excel, Word or any product that uses
VBA.
It is also used with
Visual Basic and
VB.Net
The main
ADO objects are described in these articles:
ADO Connection
ADO Recordset
ADO Command
ADO Excel
ADO Main
OLE DB
Connection Strings