Skip to main content

Hi ,

I have an excel file with 2 sheets

Sheet1 -- column names(Id,name)​

Sheet2-column name(id,name)

I am using excel as db

I need to update ​sheet2 name column where sheet2(Id) is matched with sheet1 (Id)

Could you please send me uodate query

Thanks

Mahesh​

Hello Mahesh,

 

If you are using msssql, you can use the below query for the same:-

 

update [SHEET2] set [NAME]='VALUE' where [ID] = (select [ID] from [SHEET1])

Please try this query and let m know if any questions.

 

Thank you,

Prabhakar Jha