Home | About me | EXCEL VB Programming (XL97-2003) | ACCESS Programming | EXCEL VB.Net Programming | EXCEL Spreadsheet Functions |  Material Management  |  Guestbook
 

ADO Recordset Object: Source Property

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

string = objRecordset.Source

Example

objRecordset.Open strQuery, , , adCmdTable
  some code.....
strCommand = objRecordset.Source