Well, my test has just run into problems and thrown a java.lang.OutOfMemoryError error.
I'm thinking though maybe I can use the LineNumberReader code to split the csv file into smaller parts. Maybe take 5,000 rows at a time and write them out to a new csv file. Then I can just run the processing code that I already have on each smaller file. Does that logic seem sound to you? Cheers Will -----Original Message----- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: 15 December 2006 21:11 To: CF-Talk Subject: RE: splitting large csv file into smaller parts Will, If you are interested, I can get you some sample code on how I might parse a CSV file. I could have that for you on Monday. ....................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264199 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4