Question

Excel as database

  • 25 March 2022
  • 1 reply
  • 12 views

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​


1 reply

Userlevel 4
Badge +8

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

Reply