QueryType Element (Microsoft Excel)

Specifies the type of data source.

Contained In

QuerySource

Remarks

For PivotTable reports, this element contains one of the following string constants corresponding to the type of data source: Access, ADO, ODBC, or OLEDB.

For query tables, this element contains one of the following string constants corresponding to the type of data source: Access, ADO, DAO, ODBC, OLEDB, Text, or Web.

If this element is not specified, the default data source type is ODBC.

Example

See the example in the QueryTable element topic.