This topic has not yet been rated - Rate this topic

Excel Connection Manager Editor

SQL Server 2008

Use the Excel Connection Manager Editor dialog box to add a connection to an existing Microsoft Excel workbook file.

To learn more about the Excel connection manager, see Excel Connection Manager.

Note
You cannot connect to a password-protected Excel file.

Options

Excel file path

Type the path and file name of an existing Excel workbook file (.xls), or locate the file by clicking Browse.

Browse

Use the Open dialog box to locate the Excel workbook file.

Excel version

Specify the version of Microsoft Excel that was used to create the file.

Option	Description
Excel 97-2003	File was created using Excel 97 or later.
Excel 3.0	File was created using Excel 3.0.
Excel 4.0	File was created using Excel 4.0.
Excel 5.0	File was created using Excel 95 (7.0).

First row has column names

Specify whether the first row of data in the selected worksheet contains column names. The default value of this option is True.

Tasks

How to: Loop through Excel Files and Tables by Using a Foreach Loop Container

Concepts

Integration Services Error and Message Reference

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ

Excel 2007 - is not supported

in SQL 2008 R2 BIDS (Visual Studio 2008) ... the selection - Excel 2007 is there - but can not find the file in the directory.
On top of that one has to set Debug to 32 bits ...
In Visual Studio 2010 --- there is no SSIS project ...
Thank you - MS

History

4/3/2010
JiriJ