This documentation is archived and is not being maintained.

XlImportDataAs Enumeration

Specifies the format in which to return data from a database.

Version Added: Excel 2007

Name

Value

Description

xlPivotTableReport

1

Returns the data as a PivotTable.

xlQueryTable

0

Returns the data as a QueryTable.

Show: