XlImportDataAs Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

Name

Value

Description

xlPivotTableReport

1

Returns the data as a PivotTable.

xlQueryTable

0

Returns the data as a QueryTable.

Show: