You can point to any excel file that the SQL Server can see. I can pump a DTS export to any excel file on our network.
Clint Robertson-Ravo, Neil (RX) wrote: >The problem you will have about the excel file is that it usually writes to >the SQL server local dir. > >-----Original Message----- >From: Tony Weeg [mailto:[EMAIL PROTECTED] >Sent: 04 September 2003 16:09 >To: CF-Talk >Subject: RE: query output to Excel file > > >interesting... may have to try that as an avenue ;) thanks! > >tony weeg >sr. web applications architect >navtrak, inc. >[EMAIL PROTECTED] >www.navtrak.net >office 410.548.2337 >fax 410.860.2337 > > >-----Original Message----- >From: Clint Tredway [mailto:[EMAIL PROTECTED] >Sent: Thursday, September 04, 2003 10:59 AM >To: CF-Talk >Subject: Re: query output to Excel file > > >Assuming SQL Server, the easiest way would be to do a DTS export >directly an excel file. > >If you are not using SQL Server, then there really isn't an easy way. > >Clint > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
