Share via

PivotCache.QueryType Property

  • Article
Excel Developer Reference

Indicates the type of query used by Microsoft Excel to populate the PivotTable cache. Read-only XlQueryType.

Syntax

expression.QueryType

expression   A variable that represents a PivotCache object.

Remarks

XlQueryType can be one of these XlQueryType constants.
xlTextImport. Based on a text file, for query tables only
xlOLEDBQuery. Based on an OLE DB query, including OLAP data sources
xlWebQuery. Based on a Web page, for query tables only
xlADORecordset. Based on an ADO recordset query
xlDAORecordSet. Based on a DAO recordset query, for query tables only
xlODBCQuery. Based on an ODBC data source

You specify the data source in the prefix for the Connection property’s value.

See Also