Appending data to a master database from another database

[Parasyke]

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

[Tom van Stiphout]

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