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. |