Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Technical Reference
Feature Reference
 Excel Connection Manager Editor

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
Other versions are also available for the following:
SQL Server 2008 Books Online (June 2009)
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.

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

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

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.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker