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

Appending records in another database

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a

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.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.