Export (0) Print
Expand All
Expand Minimize

XlQueryType Enumeration

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

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlADORecordset7Based on an ADO recordset query
xlDAORecordset2Based on a DAO recordset query, for query tables only
xlODBCQuery1Based on an ODBC data source
xlOLEDBQuery5Based on an OLE DB query, including OLAP data sources
xlTextImport6Based on a text file, for query tables only
xlWebQuery4Based on a Web page, for query tables only


Community Additions

ADD
Show:
© 2014 Microsoft