Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Excel Connection Manager Editor

Excel Connection Manager Editor

Updated: 12 December 2006

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.

ms186848.note(en-US,SQL.90).gifNote:
You cannot connect to a password-protected Excel file.

ms186848.note(en-US,SQL.90).gifNote:
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.

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.

Release History

12 December 2006

New content:
  • Added a note about the use of Excel 2007 data sources.

5 December 2005

New content:
  • Added note about connecting to password-protected worksheets.

Community Additions

ADD
Show:
© 2015 Microsoft