If you are familiar with DTS, the easiest way would be to create a dts package and call it from a stored proc on the page to write out the excel file. 15 minutes to get the dts right and 3 lines of cf code to call the sp. I'd really recommend at least trying it this way, dts can be quite rewarding in terms of time saved.
-- jon mailto:jonhall@;ozline.net Tuesday, November 5, 2002, 8:59:19 AM, you wrote: BD> What would be the best method for dumping a SQL table into an Excel BD> spreadsheet and allowing the user to download it? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
