topic RE: Oledb in Product Forum

Oledb

GowthamBopaiah — Wed, 15 Feb 2023 05:14:00 GMT

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
------------------------------

RE: Oledb

GowthamBopaiah — Wed, 15 Feb 2023 06:37:00 GMT

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
------------------------------

RE: Oledb

Babjee24 — Wed, 15 Feb 2023 08:50:00 GMT

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
------------------------------

RE: Oledb

GowthamBopaiah — Wed, 15 Feb 2023 08:57:00 GMT

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
------------------------------

RE: Oledb

Babjee24 — Wed, 15 Feb 2023 09:03:00 GMT

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
------------------------------

RE: Oledb

GowthamBopaiah — Wed, 15 Feb 2023 10:36:00 GMT

Thanks for the suggestion Babjee

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

RE: Oledb

sonsharm — Wed, 01 Mar 2023 07:34:00 GMT

Hi @Gowtham Bopaiah

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

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