Excel Connection Manager Editor
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.
Note
While you use an Excel connection manager to connect to a data source that uses Microsoft Office Excel 2003 or earlier, you cannot use an Excel connection manager to connect to a data source that uses Microsoft Office Excel 2007. Also, you cannot use the Microsoft Jet 4.0 OLE DB Provider to connect to an Excel 2007 data source. To connect to an Excel 2007 data source, use an OLE DB connection manager, and for Provider, select Microsoft Office 12.0 Access Database Engine OLE DB Provider. Then, on the All page of the Connection Manager dialog box, for Extended Properties, enter Excel 12.0. To load data from or to an Excel 2007 data source, use an OLE DB source or an OLE DB destination, respectively. You cannot use an Excel source or Excel destination to connect to an Excel 2007 data source.
Options
- Excel file path
Type the path and filename 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.
See Also
Other Resources
Integration Services Error and Message Reference
How to: Loop through Excel Files and Tables
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
12 December 2006 |
|
5 December 2005 |
|