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