PivotCache.QueryType Property
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.