Installing 32-bit ODBC Drivers for SmartConnect 2018 and Lower

Overview: SmartConnect 2018 and lower are 32-bit applications, requiring 32-bit ODBC drivers to read Microsoft Excel data sources. However, if a 64-bit version of Microsoft Office is installed, the installer will not install the 32-bit drivers. This article guides you through the steps to install the 32-bit drivers.

If you’d rather watch a video explaining this, see below or click here.

Steps to install the 32-bit ODBC Drivers:

1. Download the Drivers:
   • Download the 32-bit Microsoft Excel ODBC drivers from Microsoft: Microsoft Access Database Engine 2016 Redistributable
   • Select the “accessdatabaseengine.exe” file when clicking the Download button.
2. Prepare for Installation:
   • If you attempt to run “accessdatabaseengine.exe” with a 64-bit version of Office installed, you will encounter this error:
   • To avoid this, follow the steps below to install the drivers via the command line.
3. Command Line Installation:
   • Copy the “accessdatabaseengine.exe” file to a folder in the root of the C:\ drive (e.g., C:\temp).
   • Open Command Prompt as an Administrator:
     • Type “cmd” in the Windows Search bar.
     • Right-click on the Command Prompt’ and select ‘Run as Administrator’.
     • Navigate to the folder where the accessdatabaseengine.exe is located:
       • Type “cd c:\temp” and press ‘Enter’.
     • Install the drivers:
       • Type “accessdatabaseengine.exe /quiet” and press ‘Enter’.
       • If prompted by User Account Control, click ‘Yes’.
       • Several command windows will open and close during installation.
     • Once installation is complete type “exit” and press ‘Enter’ to close the Command Prompt window.

NOTE: If the /quiet parameter does not work try again using “accessdatabaseengine.exe /passive”