Collapse the table of content
Expand the table of content
Expand Minimize

XlImportDataAs Enumeration (Excel)

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:
© 2015 Microsoft