DmitryR
Scholar

Nintex RPA import Data from Excel an issue

Jump to solution

Hello,

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."

DmitryR_0-1630581085659.png

 

Labels: (1)
0 Kudos
Reply
8 Replies
michta
Nintex RPA Expert
Nintex RPA Expert

Re: Nintex RPA import Data from Excel an issue

Jump to solution

Hi, Dmitry,

 

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.

 

Thanks,

Mike

0 Kudos
Reply
DmitryR
Scholar

Re: Nintex RPA import Data from Excel an issue

Jump to solution

We are using 64-bits system only and can't change it. Do you have other solve? Does Nintex RPA works with 32-bit MS Access only?

0 Kudos
Reply
michta
Nintex RPA Expert
Nintex RPA Expert

Re: Nintex RPA import Data from Excel an issue

Jump to solution

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!

0 Kudos
Reply
DmitryR
Scholar

Re: Nintex RPA import Data from Excel an issue

Jump to solution

OK. I understood. Unfortunately, this is not suitable for our client.

0 Kudos
Reply
michta
Nintex RPA Expert
Nintex RPA Expert

Re: Nintex RPA import Data from Excel an issue

Jump to solution

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.

0 Kudos
Reply
DmitryR
Scholar

Re: Nintex RPA import Data from Excel an issue

Jump to solution

The client has updated the MS office including the "Microsoft Access Database Engine 2016 Redistributable" component, but it didn't help. 

0 Kudos
Reply
EHerrera
Nintex Employee
Nintex Employee

Re: Nintex RPA import Data from Excel an issue

Jump to solution

Hello,

 

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.

 

https://www.microsoft.com/en-us/download/details.aspx?id=54920

 

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.

 

For example:

If you downloaded the installation file in the folder:

C:\Temp\accessdatabaseengine.exe

 

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.

 

Thank you

0 Kudos
Reply
DmitryR
Scholar

Re: Nintex RPA import Data from Excel an issue

Jump to solution

This issue is related to the Russian language for the Window system. We are using a workaround - switched the system language to English.

0 Kudos
Reply