Originally Posted by
Ajax
actually you can, but not by using a linked table or selecting a table to append. And may be fussy about how you are updating. not tested for an empty destination recordset for example, or for weird column headings in excel (spaces, too long, non alpha numeric characters, etc)
create a query something like
SELECT XL.*
FROM (SELECT * FROM [sheet1$] AS xlData IN 'C:\myfolder\myfile.xlsx'[Excel 12.0;HDR=yes;IMEX=0;ACCDB=Yes]) AS XL
save it as say qryXL.
note if you have a specific range then specify column/rows e,g, [sheet1$A2:B50] or [sheet1$A:H]
now create an append query - use the query grid and select any old table and choose one of the fields to update, doesn't matter what as you will change it in the next step
then go to the sql view, change source and destination fields to the ones in your source table and excel and change the randomly selected table to qryXL.
Or if you know what the append query for sql looks like, just write the sql