Import query RESULTS from one .mdb to another 1

[ajaeger]

I have 2 databases and I need to import the results of qryABC from DatabaseA.mdb into tblABC in DatabaseB.mdb.

I'm able to do it through Access, sort of (in DatabaseB.mdb right-click in TABLES, select IMPORT, select DatabaseA.mdb, under "Import Objects" select qryABC, select "Options", select "Import Queries as Tables"). This at least gets the results of qryABC into DatabaseB.mdb. However, it's created as a new table, 'qryABC'. I need it to append to tblABC. And I need it in code.

Kinda related, is there a way to record a macro while I'm doing these steps so that I can create a shell of the code?

Anna Jaeger
iMIS Database Support

http://www.axcedesolutions.com

 

[PHV]

Why not simply play with an append query into a linked table ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ajaeger]

Duh!?! I should have thought of that, but you see I'm always trying to make things harder on myself. Thanks!

Anna Jaeger
iMIS Database Support

http://www.axcedesolutions.com