Do you happen to have some sample code I could use as a guide. I haven't really done much with DTS.
Thanks, Dave -----Original Message----- From: jon hall [mailto:jonhall@;ozline.net] Sent: Tuesday, November 05, 2002 11:49 AM To: CF-Talk Subject: Re: Dump a SQL table into an Excel spreadsheet 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
