Download and install the Excel OLEDB 2007 driver

Download OLEDB Driver for Excel 2007 allows to read Excel files from applications using ODBC or OLEDB connections. The driver for Excel 2007 is needed for example to load Excels files from SSIS. Here are the 3 steps to follow to use your files from ODBC or OLEDB connections.

How to download and install the Excel OLEDB 2007 driver to create connections?

First of all, you have to download the driver for Office Excel 2007. Secondly, install the driver with the file AccessDatabaseEngine.exe on the server. Then set up the connection, and finally use the driver by building a connection string for example from an SSIS package.

1. Download the OLEDB driver for Excel 2007

First, download the Office Excel 2007 driver installation file, available below. The ZIP file contains the AccessDatabaseEngine.exe file.

2. Install the driver

Secondly, install the driver on the server or on the machine to use it for connections.

  • Double-click on the AccessDatabaseEngine.exe file to install it on the target server.
  • Follow the instructions on the screen until the installation is complete.

3. Use the OLEDB driver for Excel 2007 in an OLEDB or ODBC connection string

Thirdly, use connection chains to call the driver.

  • If you use applications that use OLEDB, you must specify the argument “Microsoft.ACE.OLEDB.12.0” in the ConnectionString property.
  • To connect to Microsoft Office Excel type databases, add “Excel 12.0” in the connection string properties (also ConnectionString).
  • For ODBC connections, it is possible to connect to Excels files: XLS, XLSX, XLSM and XLSB types. You have to specify the elements: DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)} as well as the element DBQ=”D:\Folder\Excel_File.xlsx” which is the location of the file for example.

Be the first to comment

Leave a Reply