This documentation is archived and is not being maintained.

XlImportDataAs Enumeration 

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

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

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