Appending records in another database

[dixie]

If I have two compatible tables, but in two separate databases, can I append
the records in one table onto the records in the other by code in either a
module or a form. If the two databases were DbA and DbB and the tables were
called MyTableA and MyTableB, what would be the best way of achieving this?
I would want to append MyTableA onto the bottom of MyTableB and the code to
do it would need to be in DbB. Any suggestions?

dixie

[DC]

One way to do this is to link table b in database a. FILE>GET EXTERNAL
DATA>LINK TABLES. Then write an append query from table b to table a.

--
Dean Covey
www.coveyaccounting.com

MS-Office Certified:
http://www.microsoft.com/learning/mc...st/default.asp

"dixie" <di***@dogmail.com> wrote in message
news:42********@duster.adelaide.on.net...

If I have two compatible tables, but in two separate databases, can I
append the records in one table onto the records in the other by code in
either a module or a form. If the two databases were DbA and DbB and the
tables were called MyTableA and MyTableB, what would be the best way of
achieving this? I would want to append MyTableA onto the bottom of
MyTableB and the code to do it would need to be in DbB. Any suggestions?

dixie

[pietlinden]

dixie wrote:

If I have two compatible tables, but in two separate databases, can I append the records in one table onto the records in the other by code in either a module or a form. If the two databases were DbA and DbB and the tables were called MyTableA and MyTableB, what would be the best way of achieving this? I would want to append MyTableA onto the bottom of MyTableB and the code to do it would need to be in DbB. Any suggestions?

dixie

from ADH 2000, p 169

SELECT {fieldlist}
FROM tablelist
IN "path-and-database"

SELECT OrderID, OrderDate, LastName As Customer
FROM tblOrder INNER JOIN tblCustomer
ON tblOrder.CustomerID = tblCustomer.CustomerID
IN " d:\a2kdh\VolumeI-2370\Ch04\ch04.mdb";
Then just modify to make it an insert (SELECT INTO)query.