XlImportDataAs Enumeration

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

Version Information

Version Added: Excel 2007

Name

Value

Description

xlPivotTableReport

1

Returns the data as a PivotTable.

xlQueryTable

0

Returns the data as a QueryTable.