> I could start putting things like : "DONE" <cfabort /> at differt parts of the code (of course don't > actually update the database). See if you can narrow down which part of the algorithm is taking a long time.
Been there and done that ALL DAY... The bottle neck lies either here: <CFSET objRange= objSheet.Range("A#cnt#,B#cnt#,C#cnt#,D#cnt#,E#cnt#,F#cnt#,G#cnt#,H#cnt#,I#cn t#,J#cnt#,K#cnt#,L#cnt#,M#cnt#")> or here: <cfset record[#listgetat(column_headers,collection_cnt,",")#] = this.text> I suspect the latter. It seems like Excel is extreamly slow, but this is 2006. CF should have no problem parsing an Excel sprearsheet even it has thousands of records. Thanks, Robert Harrison ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259534 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4