Use an append query in Access to add new records from on table to an existing table. Practice while watching with the demo file: http://www.ralphphillips.com/youtube/Access-Action-Queries.accdb
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.
