With 30,000 records it would definitely be to your advantage to think about
upsizing to a mere robust dbms. I bet the speed of SQL Servers BCP would cut
down that import to less than 30 minutes, if that.
jon
----- Original Message -----
From: "Seamus Campbell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, May 26, 2001 10:26 PM
Subject: bulk updating database from txt file
> Hi
>
> I have a largish access database (30,000 records) which needs to be
updated
> from a comma delimited text file.
> There will be some updated records and some new records.
> I am not sure how to begin with this
> My worries are
> how do I do an update loop when some records will have to be inserted and
> some updated.
> Also this would presumably take a long time to do - how do I handle this
>
> Any suggestions welcome (assume I am a bear with very little brain) or any
> tutorials on this sort of thing.
>
> many thanks
>
> Seamus
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
