Szerkesztés

Megosztás a következőn keresztül:


XlQueryType enumeration (Excel)

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

Name Value Description
xlADORecordset 7 Based on an ADO recordset query
xlDAORecordset 2 Based on a DAO recordset query, for query tables only
xlODBCQuery 1 Based on an ODBC data source
xlOLEDBQuery 5 Based on an OLE DB query, including OLAP data sources
xlTextImport 6 Based on a text file, for query tables only
xlWebQuery 4 Based on a webpage, for query tables only

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.