With 20,000 records, do you actually need to create it on-demand for each user?
Can you have a scheduled task rebuild the .xls file every so often? If that would work, then you could just have SSIS dump the .xls file on your web server. This would take CF completely out of the process. m!ke -----Original Message----- From: jonese [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2008 10:09 AM To: CF-Talk Subject: Best method for Export to Excel... Hey all, I've got lots of ideas. done this a million times. but wanted to just check in with the crowd to see if maybe I've missed something new etc. I've got about 20k records in a sql 2005 DB table which i need to dump to an excel file on demand for users. Basically inside a cfthread tag I'm grabbing the 20k records from a web service, dumping them into a table, and then need to go from that table to an excel file and email / provide a download link for the end user. Best practices? super duper suggestions? thanks in advance! jonese http://www.jonese.us http://twitter.com/jonese ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
