Unable to connect to office 365/Ms excel 2106 using OLEDB

[RonikBahl]

Hi,

Can anyone help me with connection string to connect excel 2016 using oledb for B6.5 or office 365.

Thanks for your help.

Ronik

------------------------------
Ronik Bahl
RPA leader
EY
Europe/London
------------------------------

[GopalBhaire]

Connection string will be 
Provider=Microsoft.ACE.OLEDB.16.0;Data Source='C:\Users\gopal\Downloads\Test.xlsx';Extended Properties='Excel 12.0 Xml;HDR=YES;'

Make sure to install AccessDatabaseEngine.

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

[RonikBahl]

Thanks Gopal,

Can you please also tell version of AccessDatabaseEngine 

We have ACE12 which is not working.

Ronik

------------------------------
Ronik Bahl
RPA leader
EY
Europe/London
------------------------------

[GopalBhaire]

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

Do a quiet installation of 32-bit if you're running 32-bit Office.

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

[RonikBahl]

Hi Gopal,

Tried it but there are errors coming, sharing the errors as attachment

Ronik

------------------------------
Ronik Bahl
RPA leader
EY
Europe/London
------------------------------

[DaveMorris]

This should work for you. I did this recently and I have seen no negative impact on my machine. You basically delete a registry key for Office 16 Click-to-Run Extensibility Component. Before you do this on something other than your personal machine, you may want to verify with someone who knows why this registry key exists in the first place.

https://www.itsupportguides.com/knowledge-base/office-2013/solved-how-to-uninstall-office-15-click-to-run-extensibility-component/

------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------

[GopalBhaire]

The quiet installation was meant to avoid this error
Run cmd as admin type in the full file path of access db engine ie c:\download\AccessDatabaseEngine.exe /quiet 
The quiet flag will install the component without any errors

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

[AndrewRandolph · Accepted solution]

If this issue still hasn't been resolved there is a PDF on the blue prism portal that explains how to incorporate the OLEDB connection with blue prism and where to properly install here

OLEDB Connection

Access Database Engine 2016

The first link has a hyperlink to a download that doesn't work so I have included another one after for the Access Database Engine 2016

Hope this helps!

------------------------------
Andrew Randolph
Analyst
Accenture
America/New_York
------------------------------

[VeasnaKoeut]

Look at you now Andrew. Contributing for the great good!

------------------------------
Veasna Koeut
RPA Lead Developer
Accenture
America/New_York
------------------------------