xlQueryType

Specifies the type of query used to populate the query table or pivottable cache.

xlADORecordset	Based on an ADO recordset query (7)
xlDAORecordset	Based on a DAO recordset query, for query tables only (2)
xlODBCQuery	Based on an ODBC data source (1)
xlOLEDBQuery	Based on an OLE DB query, including OLAP data sources (5)
xlTextImport	Based on a text file, for query tables only (6)
xlWebQuery	Based on a Web page, for query tables only (4)

xlADORecordset

Based on an ADO recordset query (7)

xlDAORecordset

Based on a DAO recordset query, for query tables only (2)

xlODBCQuery

Based on an ODBC data source (1)

xlOLEDBQuery

Based on an OLE DB query, including OLAP data sources (5)

xlTextImport

Based on a text file, for query tables only (6)

xlWebQuery

Based on a Web page, for query tables only (4)

REMARKS

* Added in 2000.