Excel as database

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

Sign up