Are you using SQL Server? If so...there is a very easy, very quick way using DTS.
http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS -- jon mailto:[EMAIL PROTECTED] Thursday, June 5, 2003, 2:31:20 PM, you wrote: MT> Shoot me dead if this has been asked and answered, but pelase respond nonetheless so that my replacement can jump right in: MT> what is the easiest way to create a csv file from a query? What I have is a custom tag that takes a runs a query and need to genenrate a csv file and then save it to the server using cffile. MT> TIA, MT> Mike MT> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4