[AccessD] Copying Records

Hi Rocky

JC is of course correct. If this is a huge import, it will probably pay off to run queries. However, I assumed your record count is counted in hundreds and then your method is fine.

/gustav

>>> rockysmolin at bchacc.com 28-11-2009 23:16 >>>
Which is what I did and it turned out to take about 20 minutes to put the
code together - which is probably faster than trying to make the queries
behave.

R
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Saturday, November 28, 2009 1:19 PM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] Copying Records

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