XlQueryType enumeration
Office 2013 and later
Specifies the type of query used by Microsoft Excel to populate the query table or PivotTable cache.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
| Member name | Description | |
|---|---|---|
| xlODBCQuery | Based on an ODBC data source | |
| xlDAORecordset | Based on a DAO recordset query, for query tables only | |
| xlWebQuery | Based on a Web page, for query tables only | |
| xlOLEDBQuery | Based on an OLE DB query, including OLAP data sources | |
| xlTextImport | Based on a text file, for query tables only | |
| xlADORecordset | Based on an ADO recordset query |
Show: