[AccessD] Copying Records

Dear list:

I have to copy a number of records from a table in an external database to
the current back end.  The source and object tables have the same fields.
Normally I would do this by setting up a look to copy field by field, record
by record, and that works.  But it seems like there should be a more elegant
technique.

I suppose I could create links to the source tables and make an append query
to the target tables.  

Any other ideas?

MTIA

 

rocky