export from adp to mdb in code?

[BartDB]

Hello,

I'd like to export the result of an sql-statement (stored
procedure or view) from an adp-file to an mdb.

I've tried with
- 'Docmd.TransferToDatabase': possible to export entire
table to an mdb, not possible to export from select-
statement
- 'Docmd.OutputTo': possible to export stored procedure to
txt-file, not possible to export to mdb.

Do I have to create a new table in the destination
database and add record per record ??

Thanks,
Bart.
..