I have a problem with merging two large spreadsheets with no real key field.
Each spreadsheet contains data information in the form of records. Each row
is a record and each column contains the relevant field information. Each
record looks something like:
1234 56 George McMaster 56 Nowhere St Anywhere AN1 1ZA
--
There would be additional data entered in subsequent columns (fields)
relating to ongoing work.
There would be about 50k to 60k records
The two spreadsheets would contain mainly the same information, only one
would be a more up to date version with a number of deletions and additions.
The newer version would not have the additional data, but I would like to
merge this on to it.

What I would like is to somehow merge the two so that I can have the
information entered on the older database updated with the new. And of course
a flag which would highlight new records and recordes which are on the old
but not on the new.
I could create a key field by concatenating the name and address fields and
using that as a key, but beyond that, I am lost. Any help would be very
welcome.

Ray
Ray Kennedy