[AccessD] Copy Record from one db to another

Mark Simms marksimms at verizon.net
Thu Nov 10 14:10:21 CST 2011


When you say "COPY", does that mean all target records with matching keys
from the source are deleted and then inserted ?
Or is it a mixed bag where some new ones are inserted and some existing ones
updated ?


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> Sent: Thursday, November 10, 2011 2:22 PM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Copy Record from one db to another
>
> Dear List:
>
> I need to copy specific records with about 35-40 fields per record from
> one
> database to another.  No autonumber PK.  Are there any slick tricks for
> doing this?  I have the path and file name of the target and the table
> will
> be present there.  The source db is CurrentDb.
>
> MTIA
>
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.bchacc.com <http://www.bchacc.com/>
> www.e-z-mrp.com <http://www.e-z-mrp.com/>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com





More information about the AccessD mailing list