From http://www.w3schools.com (Copyright Refsnes Data)

ADO Source Property

Complete Recordset Object Reference

The Source property sets a string value or a Command object reference, or returns a String value that indicates the data source of the Recordset object.

The data source can be one of the following:

• A Command object
• An SQL statement
• A stored procedure
• A table name

This property is read/write on a closed Recordset objects and read-only for an open Recordset object.

Syntax

Complete Recordset Object Reference

From http://www.w3schools.com (Copyright Refsnes Data)