Best way to automate adding records

[baxwink]

I'm looking for suggestions on which would be the best way to add records from identical tables which are used in databases on other workstations. Scenario; I have the same databases running on different machines at different sites, I need to gather all records (from like tables) and centralize records on one machine. Ineed to be able to setup a routine which will do this at the click of a button. THanks.

 

[DougP]

Open each table<br>
in a for next loop<br>
grab fields and put them in values<br>
then write them back out to new table.<br>
<br>
<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[elizabeth]

I've never used Access replication, but I thought this scenario was the reason it was invented.<br>
?