"Steve" wrote in message
...
I have merged remote databases into a master central database many times.
The key is to append the data in higher level tables from the remote
database into the the corresponding higher level table in the master
database. This assigns a value for the primary key in the master table.
Then append the data in lower level tables from the remote database into
the the corresponding lower level table in the master database. Now you
need to update the foreign key in the lower level tables to the value of
the corresponding primary key in the master table. I would like to offer to
automate your database to be able to do this. I will charge a reasonable
fee depending on the number of tables and relationships in your database.
If you want my help, contact me.

Steve









Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP