[AccessD] Copying Records

...by virtue of habit I prefer using the DoCmd.TransferDatabase method with 
a query.

William

--------------------------------------------------
From: "Rocky Smolin" <rockysmolin at bchacc.com>
Sent: Saturday, November 28, 2009 12:10 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
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
>