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
Assembly:  Microsoft.SqlServer.DTSRuntimeWrap (in Microsoft.SqlServer.DTSRuntimeWrap.dll)

public enum DTSExcelVersion

Member nameDescription
DTSExcelVer_2007

Uses Excel 2007.

DTSExcelVer_2013

DTSExcelVer_2016

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: