There are several Custom tags availabe on the Allaire tag gallery that will
allow you to do this if you want to do it that way. Try this:
http://devex.allaire.com/Developer/Gallery/SearchResults.cfm?keywords=excel
Hope that helps,
Sam Dutkin
Programmer
Internet Development
IBS Interactive (NASDAQ: IBSX)
Phone: (856) 985-5200, x 101
Fax: (856) 985-3363
[EMAIL PROTECTED]
-----Original Message-----
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 02, 2000 5:01 PM
To: [EMAIL PROTECTED]
Subject: CF to Excel
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.
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.