I will link the spreadsheet into Access and create an append query to insert your existing Access table with the data from your spreadsheet. Anytime your spreadsheet is updated, you have to re run the query so it also update the data in your access table.
I hope it help.
Last edited by ggo; 12-02-04 at 22:59.
Reason: wrong thing
Then, without having to go into too much detail, the simplest way to bring data from excel to access is to use the DoCmd.TransferSpreadsheet function either by way of Macro or VB into a temporary table and then append the temporary data into the table you want. The DoCmd.TransferSpreadsheet function is listed in both Access Help and the VBA Object Browser. If those references don't suffice try searching to forum or msdn.microsoft.com.