Skip to main content
Nintex Community Menu Bar
Solved

Nintex RPA import Data from Excel an issue

  • September 2, 2021
  • 8 replies
  • 317 views

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

19524i8B584C58D0B75BF4.png

 

Best answer by DmitryR

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

8 replies

Forum|alt.badge.img+9
  • Scholar
  • 49 replies
  • September 2, 2021

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


  • Author
  • 17 replies
  • September 2, 2021

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?


Forum|alt.badge.img+9
  • Scholar
  • 49 replies
  • September 2, 2021

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!


  • Author
  • 17 replies
  • September 2, 2021

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


Forum|alt.badge.img+9
  • Scholar
  • 49 replies
  • September 2, 2021

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.


  • Author
  • 17 replies
  • September 3, 2021

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


  • Nintex Employee
  • 5 replies
  • September 9, 2021

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


  • Author
  • 17 replies
  • Answer
  • October 19, 2021

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