f



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

0
11/17/2006 4:02:28 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

1 Replies
802 Views

Similar Articles

[PageSpeed] 1

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.


>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

0
11/17/2006 4:30:00 PM
Reply: