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…