Export (0) Print
Expand All
Expand Minimize

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)

Dim xlQueryType1 As XlQueryType = XlQueryType.xlADORecordset

public enum XlQueryType
public enum XlQueryType
public enum XlQueryType

Member nameDescription
xlADORecordsetBased on an ADO recordset query
xlDAORecordsetBased on a DAO recordset query, for query tables only
xlODBCQueryBased on an ODBC data source
xlOLEDBQueryBased on an OLE DB query, including OLAP data sources
xlTextImportBased on a text file, for query tables only
xlWebQueryBased on a Web page, for query tables only

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Community Additions

© 2014 Microsoft