is there an easy way to merge to Database files

[CoderGeek]

I have a small problem. I have too people that both have a copy of the same database but with different data in them I would like to be able to merge the too is there any easy way to automate this

 

[Pat Hartman]

If this is a onetime conversion, link the tables of one db to the other and use append queries to append the data from the linked tables to the local tables.

If this is something that needs to be done on a regular basis, do the onetime conversion above and then look into using replication to keep the separate db's in sync.

 

[CoderGeek]

Thanks for the Response

the Data merge would be something that would be done on a daily bases