Question

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

Userlevel 7

+10

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