please help, I have an issue with importing data from the any Excel file. I use: Data - Open Data.., after preparing the data using the data import wizard, I get the following issue: "OleDbConnection is Null OR Closed."
Solved! Go to Solution.
Please try updating your Access database engine. Go to https://www.microsoft.com/en-us/download/details.aspx?id=54920 and download the 32-bit version. Then install it using the /quite flag "accessdatabaseengine.exe /quiet" from an administrative command prompt, and let us know if that fixes the error you're seeing.
Foxtrot is a 32-bit application that uses a helper app called Foxtrot64 to do interaction on 64-bit systems. That said, we need the 32-bit version of the Access database engine, and that should be installable on your system. Let me know!
Keep in mind that the installation of Nintex Bot already installs this 32-bit component and this is simply an update of that component to determine if it solves the issue you're experiencing.
Please try installing Access 2016 Redistributable again but first uninstall the currently installed version (listed as 'Microsoft Access database engine 2016' in the 'Apps & features' list). This is because the latest version will not install properly over an existing older version of Access 2016 Redistributable. It must first be manually uninstalled.
When installing the 32-bit version on an operating system that already has a 64 bit version of Office already installed on it, it must be installed through a command prompt (Run as Administrator) using the /QUIET option.
If you downloaded the installation file in the folder:
Run the following command in the Command prompt:
C:\Windows\System32> C:\Temp\accessdatabaseengine.exe /QUIET
You will not see any prompts during installation. After a few minutes, check to see if it has been installed in Windows 'Apps & features' list.