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 eSHEET2] set tname]='VALUE' where eid] = (select tid] from mSHEET1])

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

 

Thank you,

Prabhakar Jha

Reply


Terms & ConditionsCookie settings