compare 2 data bases that change each month. Only account number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 large data bases that change in a small way each month. One has an
extra 2 columns which never occurs on the new DB. Only the account number is
consistant. How can I check each for changes and merge only the new dats into
the batabase?
 
The first and fundamental question is why do you have duplicated data? This
is always going to create more work and, at worse, is a recipe for disaster.
I would suggest that you look to changing the system so that there is only
one data source.

To answer your question more directly you could add a field "Update date"
and as long as this is changed every time data is changed you will have a
point of reference on what records have been changed. You could identify
changed records by sorting on date or by filtering.

Hopefully this may just give a pointer in the right direction.

Regards.

Bill Ridgeway
Computer Solutions
 
Back
Top