Share via


DTSExcelVersion Enumeration

This API supports the infrastructure and is not intended to be used directly from your code.

This enumeration maps the Extended Properties from the connection string in an OLEDB provider to the correct version of the Excel connection manager. For more information, see ConnectionManagerExcelClass.

Namespace:  Microsoft.SqlServer.Dts.Runtime.Wrapper
Assembly:  Microsoft.SqlServer.DTSRuntimeWrap (in Microsoft.SqlServer.DTSRuntimeWrap.dll)

Syntax

'Declaration
Public Enumeration DTSExcelVersion
'Usage
Dim instance As DTSExcelVersion
public enum DTSExcelVersion
public enum class DTSExcelVersion
type DTSExcelVersion
public enum DTSExcelVersion

Members

Member name Description
DTSExcelVer_3 Uses Excel Version 3.0.
DTSExcelVer_4 Uses Excel Version 4.0.
DTSExcelVer_5 Uses Excel Version 5.0.
DTSExcelVer_8 Uses Excel 97 through Excel 2000.
DTSExcelVer_2007 Uses Excel 2007.