Access 2000

R

Rich@GDC4

I have two working databases that have the same fields but different data. I
was wondering if there this a way of doing a "compair differences" of the two
tables so I could see what data is most current. Let me put it this way, I
would like to murge the two tables into one. Is this possible???
 
T

Tom Ellison

Dear Rich:

A bit vague, but probably possible.

A query comaring every row in the two tables could show every row in one
table that does not have a match in the other. Without definitions as to
what common set of "key" columns can be used, that's about all it can do.

If you make a definition that any pair of rows having identical "key"
columns are to be compared between the two tables, then you can go somewhat
further (farther?). This will "pair up" rows not identical in the sense of
my second paragraph. Once you have examined them in this way, you may be
able to see what rules to apply to merge them into a "most current". This
will depend on how well your data design supports doing so.

You asked your question without any kind of specifics, so my response has
been equally general. That seems to be a rule about answering questions in
a newsgroup. Without making assumptions about your situation, I cannot
offer much more. In my experience, this is just what I'd likely do,
however.

Tom Ellison
Microsoft Access MVP
 
Top