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