Hi, I recently had to match up 2 sets of records. Both sets were extracted from databases and imported into excel. So 2 separate excel tables.
Both excel tables had a column for 'Route' and 'Mileage'. Both tables were plotting company assets, which were located by their mileage distance along a given route.
As the 2 excel tables were identifying the same assets but came from 2 different databases which had different additojal fields I had to link the 2 tables together.
To do this I imported the excel tables into Access. I then went into design view and simply joined route from table 1 to route on table 2, then did another join, connecting mileage on table 1 to mileage on table 2.
I then displayed the results. So if route and mileage was the same it would join the records from both tables into a new record that has effectively matched them together.
My question is whether this was the right way to go about joining the tables? Should I have created a composite key in one/ both tables and joined this way?
Thanks,
Rob.