[AccessD] Copying Records

Hi Rocky,

My first thought on this would be to do a regular 'Select - Into' update
query.  Should be pretty straightforward.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Saturday, November 28, 2009 11:11 AM
To: 'Access Developers discussion and problem solving'
Subject: [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