XlImportDataAs Enumeration
Collapse the table of content
Expand the table of content
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

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

© 2015 Microsoft