I try to get data from Excel using oledb connection (activities: Connect → Execute Query → Disconnect).
I had it working on Windows 7. Today, trying to run Robot on Windows 10, on the second connection I get the following error:
Some connection problem? has not been properly closed or a problem with access to the file?
The same Robot works fine on Windows 7.
There might be difference in the connection strings (depending on excel version). Please use proper connection string based on excel version.
Else there will be some dependency with the oledb connection on windows 10.
Solution: Access Database Engine
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.