XlQueryType Enumeration
Specifies the type of query used by Microsoft Excel to populate the query table or PivotTable cache.
Version Information
Version Added: Excel 2007
Name |
Value |
Description |
|---|---|---|
xlADORecordset |
7 |
Based on an ADO recordset query |
xlDAORecordset |
2 |
Based on a DAO recordset query, for query tables only |
xlODBCQuery |
1 |
Based on an ODBC data source |
xlOLEDBQuery |
5 |
Based on an OLE DB query, including OLAP data sources |
xlTextImport |
6 |
Based on a text file, for query tables only |
xlWebQuery |
4 |
Based on a Web page, for query tables only |