Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

XlImportDataAs Enumeration 

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

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

Dim xlImportDataAs1 As XlImportDataAs = XlImportDataAs.xlPivotTableReport

public enum class XlImportDataAs
public enum XlImportDataAs
public enum XlImportDataAs

Member nameDescription
xlPivotTableReportReturns the data as a PivotTable.
xlQueryTableReturns the data as a QueryTable.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Community Additions

© 2015 Microsoft