Showing results for 
Search instead for 
Did you mean: 

Update Excel cell data using OLEDB Execute SQl statement

Level 2

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


Hello Praneet Vankudre,

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

Refer the detailed guide here:

The Latest OLEDB Data VBO can be found here :

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.


Mukesh Kumar - Senior Automation Developer

NHS England, United Kingdom, GB


Mukesh Kumar