> Larger files (1000+ records) though - usually time out and the import > fails. Excel 2007 (.xlsx) and forward usually fails too.
A thousand records is not a huge amount, unless there are a large number of columns involved. How many columns? What portion of the process consumes the bulk of the time - reading the file or inserting that information into your database? Because if you are looping, that tends to chew up a lot of time. -Lei ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349352 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
