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.
.gif) Note: |
|---|
|
You cannot connect to a password-protected Excel file.
|
| Note: |
|---|
|
If the data source is Microsoft Office Excel 2007, the data source requires a different connection manager than earlier versions of Excel. For more information, see How to: Connect to an Excel Workbook.
|
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.
See Also