| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
QueryTable object (Excel) |
vbaxl10.chm517072 |
|
|
505b84ea-64b3-b4fe-741a-de6884eb69eb |
04/02/2019 |
medium |
Represents a worksheet table built from data returned from an external data source, such as a SQL server or a Microsoft Access database.
The QueryTable object is a member of the QueryTables collection.
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- 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
[!includeSupport and feedback]