[AccessD] Copying Records

I think I have to use an Append query, don't I? 

R

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

 


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com