Share via


PivotCache.QueryType Property (Excel)

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

Concepts

PivotCache Object Members

PivotCache Object