Here are a couple of UDF's should help. QueryToCsv http://www.cflib.org/udf.cfm?ID=556
CSVFormat http://www.cflib.org/udf.cfm?ID=404 Enjoy! Justin Hansen -------------------------- Uhlig Communications Systems Engineer -------------------------- [EMAIL PROTECTED] 913-754-4273 Office 816-695-4045 Mobile -------------------------- -----Original Message----- From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl] Sent: Tuesday, November 05, 2002 8:09 AM To: CF-Talk Subject: Re: Dump a SQL table into an Excel spreadsheet Bosky, Dave wrote: > What would be the best method for dumping a SQL table into an Excel > spreadsheet and allowing the user to download it? The easiest way is to dump it into a .csv and then have the user download that using cfcontent. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
