The easiest way is to output an Excel readable text file, like a csv or tab
delimited file.
Cary
At 02:01 PM 6/2/2000 -0700, you wrote:
>How can I take the results of a Query and save it as an Excel file?
>
>This is what I though would work.
>
>Thanks all!
>
><CFQUERY NAME="DIMS" DATASOURCE="DSTS">
> SELECT END_ITEM_ROOT_PN, END_ITEM_SN
> FROM DSTS.B_V_DSTS_ASSEMBLY
> ORDER BY END_ITEM_ROOT_PN, END_ITEM_SN
></CFQUERY>
><cfcontent type="application/msexcel">
>
><CFOUTPUT QUERY="DIMS">#END_ITEM_ROOT_PN# #END_ITEM_SN#</CFOUTPUT>
>
>Jim Ray
>Delta Program NT Administrator
>The Boeing Company
>(714) 896-2038
>Email: [EMAIL PROTECTED]
>Website: http://deltaweb.lgb.cal.boeing.com/
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.