Do you merely have to combine 2 tables into one table (realizing that you'll
have to do this multiple times for each table set)?

If so, the first thing I'd do is import each table that needs to be combined
into one of the databases (doesn't matter which one, as long as you
understand that one of the databases is old and out of date).

To do this click Tables, click new, select import table.  navigate to the
database that holds the table you want to import and select each table to be
imported. click import

once you do this you'll see that your db contains both tables from each db.

next you need to ensure that you don't have duplicate records in the table
that you are going to import.  If you are certain that the tables have unique
records, the next step is simple...

click queries, click new, click design view.  select one of the tables that
you just imported and insert EVERY field that you want to add to the existing
table. (one by one, add ALL of the fields).  next click query, select append
query, select the table you'd like to append the records to. ensure that an
"import to" field is listed for each of the fields.  if they're missing, pick
the correct field from the drop down box.

once you've finished setting up the query, click the ! to run the query.
You'll probably be warned that you are about to append ###records.  click ok
and you're done.

you'll need to set up and run a query for each of the tables that need to be
combined.

that's it...

Thank you both; much appreciated. Will give it a go.

Kind Regards

Paul.