Download and install the OLEDB driver for Excel 2010

How to download and install the OLEDB drivers and components for Excel 2010 ? This set of components is 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).

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.

How to download and install the OLEDB AccessDatabaseEngine.exe Excel driver and component for Excel 2010 ?

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:

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

2. Install the ODBC and 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 components for Office 2010

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.

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 the Excel drivers and explains how they work. Check out this article on how to calculate time difference in hours, minutes and seconds with SQL.

Be the first to comment

Leave a Reply

Your email address will not be published.