[AccessD] Copying Records

Naw, possibly dynamic SQL where you build up the SQL statement and then execute the SQL statement 
using the db object.

This has the advantage of doing all of the records at once which can be much faster depending on the 
quantity.

John W. Colby
www.ColbyConsulting.com


Gustav Brock wrote:
> Hi Rocky
> 
> .. 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.  
> 
> If so, I would use the same method as you currently use. Pure DAO or ADO.
> 
> /gustav
> 
>