http://erlandsendata.no/english/inde...badacexportado

This shows how to append data to an Access Table from Excel using VBA.
Re an update query, you can probably figure out how to loop through
the recordset and update the fields you want from Excel data.

Hth,
Merjet