[AccessD] Copying Records

Yeah - small number of records each time.   

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Sunday, November 29, 2009 12:27 AM
To: accessd at databaseadvisors.com
Subject: Re: [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


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