How to solve data replication?

[Olavxxx]

Hi,

I need to replicate data from one db to another, based on a fields value.

I asked the question in another part of the forum:

http://www.tek-tips.com/viewthread.cfm?qid=954348&page=1

I hope you can help.
ps. it's non profit and not a school assignment, I do it as a service to the public.

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster

 

[tledwards]

First use File/Get Data/Link to link the old database table to the new database. Then use an update query to change the values of current records if you need to. Use an append query to add records to the new table.