Please help me to solve this OLEDB connection issue through Blue Prism

[mskumar]

Please help me to solve this OLEDB connection issue through Blue Prism
Connection String which i am using in Blue Prism
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Data.xlsx;Extended Properties=Excel 12.0 Xml;"

View attachment 1564660561639.pngHi

 

[polineni.bhargavi]

https://www.connectionstrings.com/excel/

Hope this might help , check what is ur excel version

Thanks

 

[mskumar]

Thanks Bhargav for the reply, i have already checked the above link and also ad the respective connection string but the error says some thing else which i have attached in the thread above.

 

[Vladislav]

Hi,

Try to download and install AccessDatabaseEngine. I think that will solve your problem.

https://social.msdn.microsoft.com/F...r-is-not-registered-on-the-local?forum=vstsdb

 

[mskumar]

Ya even i did that but still the same issue ?

 

[milind100]

Hi,

Uninstall any previous AccessDatabaseEngine and download and install the one mentioned in below link.

https://www.microsoft.com/en-in/download/details.aspx?id=13255 https://www.microsoft.com/en-in/download/details.aspx?id=13255

Note: Download AccessDatabaseEngine.exe and not AccessDatabaseEngine_X64.exe

Hope this helps!!!