Oledb

[GowthamBopaiah]

Hii

Iam new to oledb connections , I want to update data to a excel for a specific cell and sometimes multiple using cell refrence . and can it be done without getting excel into collection any idea's or suggestions on this please 

------------------------------
Gowtham Bopaiah
------------------------------

[GowthamBopaiah]

while iam trying to run open action after set connection Iam getting Internal : Could not execute code stage because exception thrown by code stage: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

------------------------------
Gowtham Bopaiah
------------------------------

[Babjee24]

Hi Gowtham,

You need to install Microsoft Access DB engine both 32 and 64 bit versions for accessing excel as OLDEB. You can download that in the below link: https://www.microsoft.com/en-us/download/details.aspx?id=54920

------------------------------
Babjee Vangipurapu
Senior RPA Developer
Wonderbotz
India
------------------------------

[GowthamBopaiah]

Hii babjee thanks for the reply .But iam using company lap so external download is prohibited , Is there any other option to solave this

------------------------------
Gowtham Bopaiah
------------------------------

[Babjee24 · Accepted solution]

Hi Gowtham,

Microsoft Access DB engine is the bridge that allows you to connect to any source via OLEDB, without that connecting via a connection string to a data source is not possible.

------------------------------
Babjee Vangipurapu
Senior RPA Developer
Wonderbotz
India
------------------------------

[GowthamBopaiah]

Thanks for the suggestion Babjee

------------------------------
Gowtham Bopaiah
------------------------------

[SonamSharma]

Hi @Gowtham Bopaiah

You can try using "Set Cell Value" action related to MS Excel VBO.

------------------------------
Sonam Sharma
Manager, Blue Prism
SS&C
------------------------------