databases store data in a different structure to excel. Excel 'tables' are short and wide', database tables are 'tall and narrow'. So just a warning, applying an excel structure to a database will lead to either something that only works with a lot of effort or at worst, won't work at all.
with regards updating the db, do the following
link to the excel file - you can use code (transferspreadsheet) to do this
write a query to append the data from the linked table to it's final destination
note: with the linked table, if another spreadsheet comes along, simply replace the one you originally linked to i.e. same name/location, you do not need to relink
an alternative method would be to just use a query - syntax would be something like
Code:
INSERT INTO myTable (fld1, fld2, etc)
SELECT efld1, efld2, etc
FROM (SELECT * FROM [sheet1$] AS xlData IN 'C:\docs\filename.xlsx'[Excel 12.0;HDR=yes;IMEX=0;ACCDB=Yes]) AS XL;