Merge data in tables in Access 2000

P

Parry Again

Following a recent hardware repair, all our access database files were
unfortunately re-loaded on to our computer twice. Over the last few months
several people have been up-dating the database, and as a result we now have
several tables in several databases.

To simplify matters I need to know how to join up all these tables in these
databases to make one big database. All these databases have the same fields
but not all fields are filled. Once this has been done, Because of what has
happened there will be several names and addresses appearing twice or even
three times. I then need to sort the database so that it picks out all those
that appear more than once so that we can tidy it all up.

Hopefully someone can help us sort out this problem
 
Top