The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

XlImportDataAs Enumeration

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

Version Information
 Version Added:  Excel 2007

xlPivotTableReport1Returns the data as a PivotTable.
xlQueryTable0Returns the data as a QueryTable.

Community Additions