Not
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Represents a worksheet table built from data returned from an external data source, such as a 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
Methods
Properties
- 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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.