Appending data to a master database from another database

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

On 17 Nov 2006 08:02:28 -0800, "Parasyke" <kress1963nov22@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.

Quote:

>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

Appending data to a master database from another database

re: Appending data to a master database from another database

/bytes/development

/bytes/it

/bytes/about