Dan Waters
dwaters at usinternet.com
Sat Nov 28 12:43:12 CST 2009
Sorry - Append it is! 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:59 AM To: 'Access Developers discussion and problem solving' Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com