XlImportDataAs Enumeration
Specifies the format in which to return data from a database.
Version Information
Version Added: Excel
| Name | Value | Description |
|---|---|---|
| xlPivotTableReport | 1 | Returns the data as a PivotTable. |
| xlQueryTable | 0 | Returns the data as a QueryTable. |