YouTip

# ADO Recordset (Recordset) * * * To read data from a database, the data must first be loaded into a recordset. * * * ## Creating an ADO Table Recordset After an ADO database connection is created, as described in the previous chapter, you can then create an ADO recordset. Assume we have a database named "Northwind", we can access the "Customers" table in the database with the following code: * * * ## Creating an ADO SQL Recordset We can also use SQL to access data in the "Customers" table: * * * ## Extracting Data from the Recordset After the recordset is opened, we can extract data from it. Assume we have a database named "Northwind", we can access the "Customers" table in the database with the following code: