Download and install the OLEDB Excel 2010 driver

How to download and install the OLEDB drivers and components for Excel 2010

Download and install the set of Excel drivers components, also called Drivers Database Access 2010. Or Redistributable Microsoft Access 2010 Database Engine. It facilitates the transfer and connections between Microsoft Office Access 2010 files and Microsoft Office Excel 2010 files to databases like SQL Server (2005, 2008, 2008 R2 and 2012).

Table of Contents

How to download and install the OLEDB driver for Excel 2010?

Indeed, the Access 2010 driver makes it possible, for example, to upload an Excel 2010 file to a SQL Server 2012 database. With the help of SSIS, in the context of a Microsoft Business Intelligence project for example.

1. Download ODBC and OLEDB drivers and components for Office 2010

The complete Office Excel 2010 driver installation file is available below. The ZIP file contains the AccessDatabaseEngine.exe file. Download the Excel 2010 AccessDatabaseEngine Driver from the official Microsoft website, also called Redistributable Microsoft Access 2010 Database Engine.

Two files are availalbe:

One for the 32bits Windows version : AccessDatabaseEngine.exe
The second one for the 64 Bits Windows versions : AccessDatabaseEngine_X64.exe

2. Install the OLEDB drivers and components for Office 2010

Secondly, install the drivers on the Windows machine.

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

3. Using the OLEDB Excel 2010 driver with Office

Finally, make use of the drivers by creating Excel connections using the drivers.

If you are using 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 14.0” to the connection string properties (also ConnectionString).
For ODBC connections, it is possible to connect to Excels files: XLS, XLSX, XLSM, XLSB. The elements must be specified: DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)} as well as the element DBQ=”D:\Dossier\File_Excel.xlsx” which is the location of the file for example.

List of compatible Windows systems

Finally, the operating systems supported by the Microsoft Office Database Access 2010 drivers and components are the following:

For client versions, the driver is compatible with Windows 10, Windows 8, Windows 7 (seven), Windows XP Service Pack 3 and finally Windows Vista Service Pack 1.
On the server side, the driver is compatible with these versions: Windows Server 2008 R2 and Service Pack 2, Windows Server 2003 R2 32 bits and 64 bits.

To conclude, this article allows you to download and to install the OLEDB Excel 2010 driver and explains how its works. Check out this tutorial to calculate time difference in hours, minutes and seconds with SQL.