xlQueryType

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

xlADORecordsetBased on an ADO recordset query (7)
xlDAORecordsetBased on a DAO recordset query, for query tables only (2)
xlODBCQueryBased on an ODBC data source (1)
xlOLEDBQueryBased on an OLE DB query, including OLAP data sources (5)
xlTextImportBased on a text file, for query tables only (6)
xlWebQueryBased 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.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top