I'll make a recommendation here that may or may not apply, but may be worth noting. This is assuming ms sql Server.
Insert...values... Insert...values... , n Will be much slower from SQL perspective than: Insert... Values(...) , (...) , (...) , n Or Begin tran Insert... Values... Insert... Values... , n Commit tran First option is preferred. I only mention this as cfthread will just speed up the sql statement generation (ie , looping over the spreadsheet) and not the actual sql execution time (or at least it sounds like in this instance) . You may be able to include some of these sql performance tweaks to improve performance further. Byron Mann Lead Engineer & Architect HostMySite.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:359687 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
