Merging Data

[Josh Grameson]

I have an application that is run at various branches of a company.

This is a standalone database. Each branch is the same, only the data is
different. At a central location the client would like to periodically merge
the data from the individual offices into a central database for viewing and
reporting. There is no Internet or Network of any kind.



My question is what would be the best way to approach this - writing code to
Export/Import or does Replication for work for such a situation or perhaps
something else?

 

[Danny J. Lesandrini]

Josh:

I wrote an article about this some time ago that might help. There's also a
download with the article, but there's an even better version of it at my web
site. I recommend that you read the article and download the new code.

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

New Code
http://amazecreations.com/datafast/daaug.aspx

This may or may not help you with your specific problem. It's not replication,
but merging. Was designed to combine data from two different sites, where
the intersection of data was minimal. (Statuses, codes and maybe some contacts)