Database Update query for two different excel files

Hi All,

How to use the update query if I have two different excel files?
I have 2 sheets, one in each of the excel files.

I know to use the update query if I have both the sheets in the same excel…like below
"Update [Sheet1$],[Sheet2$] Set [Sheet1$].[Column1]=“Sachin” where …=…

Please solve for me…

Thanks
Deba

hi anyone can help on this?