is it possible to do a compare in Access 2000

[Joanne]

I need to compare 2 data bases in Access 2000. Can it be done? I downloaded
Compare Data Wiz and it doesn show as an add-in. Anyone?
Thanks,
Joanne

 

[Jeff Boyce]

Joanne

Technically speaking, if you are actually trying to "compare 2 databases",
you'd need to compare record by record between all tables in both, then
query by query in both, then .... I'm not aware of such a facility in
Access, although you might be able to do something like that with a
third-party tool.

If you mean "compare 2 tables", another responder pointed out the "unmatched
query"...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Joanne]

Bonnie,
You are so right, I'm an oldtime mainframe programmer from way back;
started with punch cards. PC's are new to me and I'm trying to learn new
terminology and software.
I have a list of doctor beeper number, dr name, dr address in 2 files
from 2 different systems. I need to "weed out" any records that are on both
files, ending up with only doctors who are NOT on both files. Will this
unmatch query work on this? Can you give some direction on how I would
accomplish this? Thanks for your help.
-- Joanne

 

[Jeff Boyce]

Joanne

An unmatched query between your two "lists" (tables) will help identify
those in one and not the other ... BUT!

If you have that kind of background, you know all too well that the
following will NOT match:

Table1
John Doe 12345 Elm Street

Table2
John J. Doe 12345 Elm St

But it's a start!

Open an Access database and either link to or import the two lists.

Create a new query and select the wizard to help you step through creating
an Unmatched query.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer]

And if you want a combined list of all that are in Table1 and not in table2
plus all that are in table2 and not in table1, you will need to use a UNION
Query to combine the two unmatched queries.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Joanne]

Thank you all for your help! I was successful in run the Unmatched. I
happened to stumble onto this site and so glad I did!
-- Joanne

If you need to weed it a little closer after applying Jeff's suggestion, you
can play with the LIKE() and INSTR() functions in the query.

Bonnie
http://www.dataplus-svc.com

Bonnie,
You are so right, I'm an oldtime mainframe programmer from way back;
started with punch cards. PC's are new to me and I'm trying to learn new
terminology and software.
I have a list of doctor beeper number, dr name, dr address in 2 files
from 2 different systems. I need to "weed out" any records that are on both
files, ending up with only doctors who are NOT on both files. Will this
unmatch query work on this? Can you give some direction on how I would
accomplish this? Thanks for your help.
-- Joanne

Hi Jeff,

[quoted text clipped - 24 lines]

Thanks,
Joanne