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.