Recordset Property
Applies To
QueryTable object.
Description
Returns or sets a Recordset object that's used as the data source for the specified query table. Read/write.
Remarks
If this property is used to overwrite an existing recordset, the change takes effect when the Refresh method is run.
Example
This example changes the Recordset object used with query table one and then refreshes the query table.
With Worksheets(1).QueryTables(1)
.Recordset = OpenDatabase("C:\Nwind.mdb").OpenRecordset("employees")
.Refresh
End With