When adding an excel sheet to datalinq as an ADODB source an error may appear when testing connection. "Failure: Provider cannot be found. It may not be properly installed" This means the Access database engine needs to be installed.
As Datalinq is a 32 bit software we need to install 32 bit Access Database Engine to use the XSLX ADODB Datalinq template. If 64 bit Microsoft Office is currently installed we will run into an error and not be able to install Access Database Engine the traditional method. The error will look something like this:
You cannot install the 32-bit version of Microsoft Access Database Engine 2010 because you currently have 64-bit Office products installed
If this happens we will need to proceed with a quiet install of Access Database Engine through Command Prompt. The following is a link to download Microsoft Access Database Engine 2010. Please ensure to use the 32 bit edition:
1. Open Command Prompt
2. Drag the 32 bit accessdatabasengine.exe installer onto the Command Prompt window
3. Add /quiet after the file path that is generated
Note: It should look something like this. The file path will change depending on where the installer is saved.
4. Hit enter
The install should start. Once complete you can verify it installed in Windows Programs and Features