Access database engine 2016 Excel driver

Driver Access database engine 2016 for Excel, in 32 or 64 bits, is required to connect to Excel working with connections to Office files from other systems. Indeed, to connect to Office Excel files, install the Excel 2016 drivers and components. This set of components is called Driver Database Access 2016 or Redistributable Microsoft Access 2016 Database Engine.

It facilitates, for example, data transfer and connections between Microsoft Office Excel files with the extensions XLS, XLSX, XLSM, XLSB on the one hand, and databases such as SQL Server 2008, 2008 R2, 2012, 2016 and 2019 on the other.

Download the Access Database Engine 2016 driver for Excel

The Access 2016 driver allows, for example, to load an Excel 2016 file into a SQL Server 2012 database. With the help of SSIS, in the context of a Microsoft Business Intelligence project for example.

1. Download the OLEDB drivers with the Office 2016 component

The complete Office Excel 2016 driver installation file is available below. It is available directly from the official Microsoft website:

Microsoft Access 2016 Redistributable Database Engine

In addition, two versions are available:

  • Accessdatabaseengine.exe is the 32-bit version
  • Accessdatabaseengine_X64.exe for the 64-bit version

2. Install the ODBC and OLEDB drivers and components for Office 2016

Second, install the drivers on the Windows client or server.

  • Double-click the AccessDatabaseEngine.exe or Accessdatabaseengine_X64.exe file to install it on the target machine.
  • Follow the step-by-step instructions on the screen until the installation is complete.

Using the components for Office 2016

Finally, to call the drivers, create connections to Excel like this:

  • For OLEDB applications, specify the argument “Microsoft.ACE.OLEDB.12.0” in the ConnectionString property.
  • To connect to Microsoft Office Excel type databases, add “Excel 14.0” in the ConnectionString property.
  • Finally, for ODBC type connections, it is possible to connect to Excel files: XLS, XLSX, XLSM, XLSB. Specify the following elements: 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.

List of Windows systems compatible with the Access database engine 2016

Finally, the Microsoft operating systems supported by the Microsoft Office Database Access 2016 drivers and components are available below.

On the client side, the driver is compatible with :

  • Firstly, Windows 10
  • Windows 8
  • Second, Windows 7 (Seven)
  • Windows Vista Service Pack 1
  • And finally, Windows XP Service Pack 3

For the server versions, the component is compatible with these versions:

  • First, Windows Server 2012 R2
  • Windows 10 Server
  • Windows Server 2008 R2 version
  • Finally, Windows Server 2003 R2 (in 32-bit and 64-bit versions)

To conclude, this article allows you to download and install the Excel Driver Access database engine 2016 in 32 bit or 64 bit version and explains how it works.

Here is an article on how to manage Excel column data types from an SSIS package.

Be the first to comment

Leave a Reply

Your email address will not be published.


*