XlQueryType Enumeration
Specifies the type of query used by Microsoft Office Excel to populate the query table or PivotTable cache.
Version Information
Version Added: Excel 2007
| Name | Value | Description |
|---|---|---|
| xlADORecordset | 7 | Based on an ADO recordset query |
| xlDAORecordset | 2 | Based on a DAO recordset query, for query tables only |
| xlODBCQuery | 1 | Based on an ODBC data source |
| xlOLEDBQuery | 5 | Based on an OLE DB query, including OLAP data sources |
| xlTextImport | 6 | Based on a text file, for query tables only |
| xlWebQuery | 4 | Based on a Web page, for query tables only |