Update Excel cell data using OLEDB Execute SQl statement

PraneetVankudre — Thu, 23 Mar 2023 10:32:00 GMT

Hello Team,

I have a excel with few columns, I would like to update the cell of "cases assigned" column where the Last name is "Vankudre", Also I have a exact cell name in hand.

I am using this for now

"UPDATE [Sheet1$] SET [Cases Assigned]=""231"" where [Last Name]=""Vankudre""

can you please suggest me with directly updating to Excel sheet itself or do i need to update collection and update back to Excel.?

------------------------------
Praneet Vankudre
------------------------------

RE: Update Excel cell data using OLEDB Execute SQl statement

Mukeshh_k — Thu, 23 Mar 2023 11:44:00 GMT

Hello Praneet Vankudre,

Make sure you use the right version of OLEDB drivers installed in your system.

Refer the detailed guide here: https://higherlogicdownload.s3-external-1.amazonaws.com/BLUEPRISM/56f3f77f-6c92-4a75-9e66-0b0ed2f6e054_file.pdf?AWSAccessKeyId=AKIAVRDO7IEREB57R7MT&Expires=1679575089&Signature=n9JE0jawnaJCnrBoqXLoNrC%2BymM%3D

The Latest OLEDB Data VBO can be found here : https://digitalexchange.blueprism.com/dx/entry/3439/solution/data---oledb

Look out for Set connection String action in the Object and provide the source excel file, something like this:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source="C:\Users\User\Desktop\Sample.xslx";Extended Properties='Excel 12.0;HDR=YES;'

"HDR=Yes;" indicates that the first row contains column names, not data. "HDR=No;" indicates the opposite.

Open the connection with Target File ready and you can directly write the operation on the excel worksheet using Execute command.

------------------------------
Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

Regards,

Mukesh Kumar - Senior Automation Developer

NHS England, United Kingdom, GB
------------------------------

topic Update Excel cell data using OLEDB Execute SQl statement in Product Forum

Update Excel cell data using OLEDB Execute SQl statement

RE: Update Excel cell data using OLEDB Execute SQl statement