XlQueryType Enumeration
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)
Usage
Dim xlQueryType1 As XlQueryType = XlQueryType.xlADORecordset
Syntax
Public Enum XlQueryType
public enum XlQueryType
public enum class XlQueryType
public enum XlQueryType
public enum XlQueryType
Members
| Member name | Description |
|---|---|
| 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 |
| xlOLEDBQuery | Based on an OLE DB query, including OLAP data sources |
| xlTextImport | Based on a text file, for query tables only |
| xlWebQuery | Based on a Web page, for query tables only |
Platforms
Development Platforms
Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000