I have an excel file with 2 sheets
Sheet1 -- column names(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
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.