[AccessD] Copying Records

For a straight record copy that works.  But in this case I'm importing
header and detail records, so the imported detail records have to use the PK
of the new header records in the target table as the FK.  

Rocky
 

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

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