Upravit

Sdílet prostřednictvím

XlQueryType Enum

  • Reference

Definition

Namespace:
Microsoft.Office.Interop.Excel
Assembly:
Microsoft.Office.Interop.Excel.dll

Specifies the type of query used by Microsoft Excel to populate the query table or PivotTable cache.

public enum class XlQueryType
public enum XlQueryType
Public Enum XlQueryType
Inheritance
Enum
XlQueryType

Fields

Name Value Description
xlODBCQuery 1

Based on an ODBC data source
xlDAORecordset 2

Based on a DAO recordset query, for query tables only
xlWebQuery 4

Based on a Web page, for query tables only
xlOLEDBQuery 5

Based on an OLE DB query, including OLAP data sources
xlTextImport 6

Based on a text file, for query tables only
xlADORecordset 7

Based on an ADO recordset query

Applies to