Compare table for changed data

  • Thread starter Thread starter Angus 1701
  • Start date Start date
A

Angus 1701

Hello, I am looking into buying access 2007 but I am unsure if it will be
able to compare two tables and to highlight what data has changed. More
details:

Every day I need to compare a newly imported table of about 200,000 records
with the day before table. The type of data that the two tables will contain
will be identical (e.g. same columns) its just that prices, stock etc that
might have changed and maybe some new rows/entries added - I need Access to
output which rows have changed data and also which rows are new or have been
deleted.

Please note that when access compares the tables it needs to keep in mind
that the two tables data row positions might be different e.g. product 29
might now be on row 28 as a product above this was removed from table. So I
think access will need to ask me what column on both tables it can use to
identify the same product.

I hope this makes sense and that someone can let me know if and how this can
be done in access.

Thanks,
Angus
 
Angus

In order to compare two tables, Access needs to have one/more fields in
common.

When you say "Product29" is that like a product_ID, or are you saying the
product that used to be in row 29?

If the former, then both tables have a common ID field. If the latter, you
better hope there are unique combinations of fields within each record so
Access can compare!

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top