exporting data to a comma dilimeted file

Is there a way with coldfusion to take data and export to a comma delimited file. I would use excel but too much data.

 

You could use the CFCONTENT tag to do something like this:

<cfsilent>
  <cfquery datasource="MyDatasource" name="MyQuery">
    select * from table
  </cfquery>
</cfsilent><cfcontent type="text/csv"><cfheader name="Content-Disposition" value="attachment; filename=export.csv">
<cfoutput query="MyQuery">#column1#,#column2#,#column3##Chr(13)#</cfoutput>

Code (markup):