QueryTable Object (Excel)

Represents a worksheet table built from data returned from an external data source, such as an SQL server or a Microsoft Access database.

Remarks

The QueryTable object is a member of the QueryTables collection.

Example

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

Events

Name
AfterRefresh
BeforeRefresh

Methods

Name
CancelRefresh
Delete
Refresh
ResetTimer
SaveAsODC

Properties

Name
AdjustColumnWidth
Application
BackgroundQuery
CommandText
CommandType
Connection
Creator
Destination
EditWebPage
EnableEditing
EnableRefresh
FetchedRowOverflow
FieldNames
FillAdjacentFormulas
ListObject
MaintainConnection
Name
Parameters
Parent
PostText
PreserveColumnInfo
PreserveFormatting
QueryType
Recordset
Refreshing
RefreshOnFileOpen
RefreshPeriod
RefreshStyle
ResultRange
RobustConnect
RowNumbers
SaveData
SavePassword
Sort
SourceConnectionFile
SourceDataFile
TextFileColumnDataTypes
TextFileCommaDelimiter
TextFileConsecutiveDelimiter
TextFileDecimalSeparator
TextFileFixedColumnWidths
TextFileOtherDelimiter
TextFileParseType
TextFilePlatform
TextFilePromptOnRefresh
TextFileSemicolonDelimiter
TextFileSpaceDelimiter
TextFileStartRow
TextFileTabDelimiter
TextFileTextQualifier
TextFileThousandsSeparator
TextFileTrailingMinusNumbers
TextFileVisualLayout
WebConsecutiveDelimitersAsOne
WebDisableDateRecognition
WebDisableRedirections
WebFormatting
WebPreFormattedTextToColumns
WebSelectionType
WebSingleBlockTextImport
WebTables
WorkbookConnection

See also

Excel Object Model Reference