ADO Recordset

To read data from a database, the data must first be loaded into a Recordset.

Create an ADO Table Recordset

After the ADO Database Connection is created, as described in the previous chapter, you can create an ADO Recordset.

Suppose we have a database named "Northwind", we can access the "Customers" table in the database with the following code:

Create an ADO SQL Recordset

We can also use SQL to access the data in the "Customers" table:

Extract data from a Recordset

After the Recordset is opened, we can extract data from it.

Suppose we use a database named "Northwind", we can access the "Customers" table in the database with the following code: