By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,093 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

Appending data to a master database from another database

P: n/a
How can I, without using Replication technology, append a table in my
master database from data in another database? I have several field
offices with sales data that I want, on demand, to append up to my home
office Master database... any ideas? Thanks!!!! Dav

Nov 17 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 17 Nov 2006 08:02:28 -0800, "Parasyke" <kr************@yahoo.com>
wrote:

Attach tables from the Child database to the Master, and run Append
queries.
Or forego the table attachments and use the IN clause to specify the
Child database. Off the top of my head:
insert into MyTable
select * from MyTable IN 'c:\test\child.mdb'

-Tom.

>How can I, without using Replication technology, append a table in my
master database from data in another database? I have several field
offices with sales data that I want, on demand, to append up to my home
office Master database... any ideas? Thanks!!!! Dav
Nov 17 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.