From: John... Visio MVP on
"Steve" <notmyemail(a)address.com> wrote in message
news:OhRdxPx4KHA.4888(a)TK2MSFTNGP06.phx.gbl...
>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



From: Rlong via AccessMonster.com on
Hi Steve and John,

Thanks for both of your posts. I appreciate the offer to consult, and the
warning. At this point I'm not interested in the consulting avenue, but would
prefer to continue with the newsgroup so that I can learn how to do this in
the process. I'd ask that this thread not turn into a discussion of for-pay
services as some others have. Again...thanks to you both.

If anyone has any additional thoughts related to my last post I'd be keen to
hear them.

Thanks.



John... Visio MVP wrote:
>>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
>[quoted text clipped - 9 lines]
>>
>> 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

--
Message posted via http://www.accessmonster.com

From: Steve on
Study my post; I gave you the process you need to use.

Steve


"Rlong via AccessMonster.com" <u58125(a)uwe> wrote in message
news:a6f959609891c(a)uwe...
> Hi Steve and John,
>
> Thanks for both of your posts. I appreciate the offer to consult, and the
> warning. At this point I'm not interested in the consulting avenue, but
> would
> prefer to continue with the newsgroup so that I can learn how to do this
> in
> the process. I'd ask that this thread not turn into a discussion of
> for-pay
> services as some others have. Again...thanks to you both.
>
> If anyone has any additional thoughts related to my last post I'd be keen
> to
> hear them.
>
> Thanks.
>
>
>
> John... Visio MVP wrote:
>>>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
>>[quoted text clipped - 9 lines]
>>>
>>> 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
>
> --
> Message posted via http://www.accessmonster.com
>


From: John... Visio MVP on
"Steve" <notmyemail(a)address.com> wrote in message
news:ujortR94KHA.5548(a)TK2MSFTNGP04.phx.gbl...
> Study my post; I gave you the process you need to use.
>
> Steve


and the answer to that question is still...





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