You can also send email and attachments through DTS using CDONTS. And you can manipulate Excel files through DTS using ActiveX Script Task. You can then schedule your package through SQL Server Jobs or you can call it manually through COM (check out cfcomet.com for more details).
Mark -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:13 AM 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 Get the mailserver that powers this list at http://www.coolfusion.com