STORED PROCEDURE -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 16:13 To: CF-Talk Subject: RE: query output to Excel file
trouble is, I cant do it all in 1 query, I have cf logic that HAS to be there, and it is then emailed to a client :( so, is there a way to take a cfquery object that is returned, and just dump that into something, and send it, versus writing line by line by line.... tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -----Original Message----- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -----Original Message----- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
