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)

public enum XlQueryType

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