Combine databases

[Jim Clark]

I have 16 access (97) databases that came from a document
imaging company. I need to combine the "index1" field
from the "indexing" table in each of the 16 databases so
that I can compare the list of document numbers we sent
off against the list they sent back (in the mdb files).
What is the easiest way to pull all the items in the
index1 field in all of the indexing tables into one file?

 

[tina]

you could try this: save the dbs (or copies) to your hard drive (for
maximum speed vs "on the server"), open a new blank db, link the pertinent
table(s) from each of the 16 others, write a UNION query to put all the
index1 data together in one column. then run an "unmatched" query between
your list of document numbers and the UNION query.

hth