Transfer of data from excel to access
 

I am posting this on both excel & access boards because I
am not sure where it should go, please forgive the
duplication.

I am using excel as a data input, multiple files, same
format, with 2 pages that contain data formatted to be
exported to a single access file for reporting. What I
want is a macro in excel that a user can just click to
export the two sheets to their respected access tables in
the same database.

The second part of the problem, is I then want to delete
any duplicated records in access to leave be with only the
records that have been added or changed since last
export. Please remeber that the data needs to come from
many excel files.

Thanks in advance, Chris Beardsley