DTSExcelVersion Enumeration

 

This API supports the product 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.Sql2012
Assembly:  Microsoft.SqlServer.DTSRuntimeWrap (in Microsoft.SqlServer.DTSRuntimeWrap.dll)

public enum class DTSExcelVersion

Member nameDescription
DTSExcelVer_2007

Uses Excel 2007.

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.

Return to top
Show: