Easily copy a record to a table

cc_at_zqwe.com
Date: 09/27/04 

Date: Mon, 27 Sep 2004 21:08:41 GMT

Scenario:

I have identical tables in two separate access databases. With ado I
want to use sql to query a single record from one table in a database,
and then with a few lines of code take that record and copy it to the
other identical table in the other .mdb file without using an INSERT
sql statement.

I just want to plop the record/recordset object field values into the
other table's fields very easily.

I was thinking maybe an intermediary stream object would do this for
me in some way?

Any suggestions?