XlImportDataAs enumeration (Excel)
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. |
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.