Access Database Engine 2016 Excel driver for SSIS

Download, install and use the Excel Access Database Engine 2016 drivers for SSIS.

Download the named drivers Access database engine 2016 for MS Office is needed to connect to Excel from other systems like SSIS. It is available in 32-bit or 64-bit. Indeed, to connect to Office Excel files, installing the drivers on the system is necessary. 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 Excel files (with the extensions XLS, XLSX, XLSM, XLSB) on the one hand, and SQL Server databases on the other.

Download the Access Database Engine 2016 Excel driver for Integration Services

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:

  1. Accessdatabaseengine.exe is the 32-bit version
  2. 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.

3. Use the components for Office 2016 with SSIS

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

  1. For OLEDB applications, specify the argument “Microsoft.ACE.OLEDB.12.0” in the ConnectionString property.
  2. To connect to Microsoft Office Excel type databases, add “Excel 14.0” in the ConnectionString property.
  3. 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 versions 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.