QueryTable Object

Description

Represents a worksheet table built from data returned from an external data source, such as an SQL server or a Microsoft Access database. The QueryTable object is a member of the QueryTables collection.

Using the QueryTable Object

Use QueryTables(index), where index is the index number of the query table, to return a single QueryTable object. The following example sets query table one so that formulas to the right of it are automatically updated whenever it's refreshed.

Sheets("Sheet1").QueryTables(1).FillAdjacentFormulas = True

Properties

Application property, BackgroundQuery property, Connection property, Creator property, Destination property, EnableEditing property, EnableRefresh property, FetchedRowOverflow property, FieldNames property, FillAdjacentFormulas property, HasAutoFormat property, Name property, Parameters property, Parent property, PostText property, Recordset property, Refreshing property, RefreshOnFileOpen property, RefreshStyle property, ResultRange property, RowNumbers property, SaveData property, SavePassword property, Sql property, TablesOnlyFromHTML property.

Methods

CancelRefresh method, Delete method, Refresh method.