DTSExcelVersion Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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.
public enum class DTSExcelVersionpublic enum DTSExcelVersiontype DTSExcelVersion = Public Enum DTSExcelVersion- Inheritance
-
DTSExcelVersion
Fields
| Name | Value | Description |
|---|---|---|
| DTSExcelVer_3 | 0 | Uses Excel Version 3.0. |
| DTSExcelVer_4 | 1 | Uses Excel Version 4.0. |
| DTSExcelVer_5 | 2 | Uses Excel Version 5.0. |
| DTSExcelVer_8 | 3 | Uses Excel 97 through Excel 2000. |
| DTSExcelVer_2007 | 4 | Uses Excel 2007. |
| DTSExcelVer_2013 | 5 | |
| DTSExcelVer_2016 | 6 |