im good on dts, that's cool, just never considered that as an option...too many options too many things to code, cant think of 'em all...thats what I have cftalk :) all these good ideas...
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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
