Try the Developer's Exchange. I know there are custom tags (mabye UDFs as well from cflib.org) out there to produce Excel files from queries. It should make your life easier ;-)
Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: <"Chakka>; <Sudheer <[EMAIL PROTECTED]>> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 14, 2003 10:10 AM Subject: Exporting to Excel from SQlServer using ColdFusion > Hi, > > Can anybody send me the code snippet using I can export the data to > Excel spread sheet. I am able to create a '.csv' file but not a '.xls' file. > > When I am using the '.xls' for creating the file it is dumping all > the information, using a coma delimited list into one column and not > separating them into separate columns. > > Can anybody give me code snippet or direction in which I have to > work > for this. > > The code I am using is: > > <cffile action="WRITE" addnewline="Yes" file="USE_THIS_FOR_AWARDS.csv" > output="AWARDID, LASTNAME, FIRSTNAME, MIDDLENAME, COURSENAME, SEMESTER, > SCHOOLNAME"> > > <cfoutput query="awardsList"> > <cffile action="APPEND" addnewline="Yes" file="USE_THIS_FOR_AWARDS.csv" > output="#AWARDID#, #LASTNAME#, #FIRSTNAME#, #MIDDLENAME#, > #COURSENAME#, #SEMESTER#, #ORGANIZATIONNAME#"> > </cfoutput> > > > Any help is appreaciated!! > - Sudheer > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
