Hmm Seamus,
commonw problem I would suspect as most sites and people are finally
getting to the data value :)
Interested in hearing what recommendations you get...
I have some stuff of my own that isn't so serious as far as
reliability... I do bulk dumps and bulk imports...
essentially, it is a big query... the a loop that transcends down the
entry list running computations and checking on a per item basis,
writing the file to the master database, ignoring it if it remains the
same....
big queries tend to crash... so you might have to step through the
process in 2-5k pieces...
-paris
[finding the future in the past, passing the future in the present]
[connecting people, places and things]
-----Original Message-----
From: Seamus Campbell <[EMAIL PROTECTED]>
Date: Sun, 27 May 2001 12:26:02 +1000
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
