You basically have a couple of options (there are obviously many more ways, these are the two approaches that I would take):
1) if it's a small file, just read it into memory and loop through the contents of the file 2) if it's a large file, set up a Microsoft Access database to use an external file (the .csv file) for its data. Performance will be MUCH better than read and parse with CF, and gives you the advantage of working with the data just like you would with any other recordset. I use this for a regular 35,000 record data import and it takes minutes compared to hours using the other approach. Pete On Wed, Mar 4, 2009 at 5:54 AM, Glyn Jackson <[email protected]>wrote: > > Hi everyone, > > I have a CSV file I need to take the values out of and update a database > with them. Any suggestion or best ways to do this? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320106 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
