Error on the second connection with Excel using sql oledb connection - win10

#1

Hi,
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:

UiError

Some connection problem? has not been properly closed or a problem with access to the file?
The same Robot works fine on Windows 7.

thanks
Mac

#2

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.

Regards,
Karthik Byggari

1 Like
#3

Solution: Access Database Engine

#4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.