Share via


XlQueryType Enumeration

Specifies the type of query used by Microsoft 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