| title | api_name | ms.assetid | ms.date | ms.localizationpriority | |
|---|---|---|---|---|---|
XlQueryType enumeration (Excel) |
|
8a0f70d4-5536-3125-cd75-d23212c91868 |
06/08/2017 |
medium |
Specifies the type of query used by Microsoft Excel to populate the query table or PivotTable cache.
| 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 webpage, for query tables only |
[!includeSupport and feedback]