Merging Data from One Database into Another

[Guest]

Access 2003. We have an Access database that we distribute to the field.
Each of our locations enters data into the database via the forms we have set
up. Our field locations are not networked together, and hence each have
their own copy of the database. We would like to be able to have our folks
send their completed databases to our headquarters when the data has been
entered, and be able to merge them all into one database. How may this be
accomplished?

By the way, each instance of the database has the same structure (tables,
queries, forms, modules, etc.). They will just have different data entered.

Thanks for any help you may give. God bless.

 

[Danny J. Lesandrini]

It could be as simple as performing some append queries, or it could be quite
complicated. I once created a tool for merging multiple client data files, but
it's not a utility and will not work on your data. However, the process, and the
forms I used might prove beneficial. There's a published article at DBJ

http://www.databasejournal.com/features/msaccess/article.php/2236471

I thought the article has a code download, but I don't see the link right now, so
you'll have to go here for the code ...

http://amazecreations.com/datafast/daaug/MergeDbs.zip

Cheers