Connect to an Excel Workbook

Connect to an Excel Workbook

 

Applies To: SQL Server 2016 Preview

To connect an Integration Services package to a Microsoft Office Excel workbook requires an Excel connection manager.

You can create these connection managers from either the Connection Managers area in SSIS Designer or from the SQL Server Import and Export Wizard.

Providers and drivers for Microsoft Excel and Access files

You may have to download the OLE DB providers and drivers for Microsoft Office files if they're not already installed. Later versions of the provider can open files created by earlier versions of Excel.

If the computer has a 32-bit version of Office, then you have to install the 32-bit version of the drivers, and you also have to ensure that you run the wizard or the Integration Services package that it creates in 32-bit mode.

Microsoft Office version

Download

2007

2007 Office System Driver: Data Connectivity Components

2010

Microsoft Access 2010 Runtime

2013

Microsoft Access 2013 Runtime

To create an Excel connection manager from the Connection Managers area

  1. In SQL Server Data Tools (SSDT), open the package.

  2. In the Connections Managers area, right-click anywhere in the area, and then select New Connection.

  3. In the Add SSIS Connection Manager dialog box, select Excel, and then configure the connection manager.

    For information about the configuration options that are available for this connection manager, see Excel Connection Manager Editor.

To create an Excel connection from the SQL Server Import and Export Wizard

  1. Start the 32-bit version of the SQL Server Import and Export Wizard.

  2. On the Choose a Data Source page, for Data Source, select Microsoft Excel, and then configure the Excel connection.

    For information about the configuration options that are available for this connection type, see Excel Connection Manager Editor.

Community Additions

ADD
Show:
© 2016 Microsoft