Mark Breen
marklbreen at gmail.com
Sat Sep 4 11:54:19 CDT 2010
Hello to everyone that replied to this, Thanks for your responses. You have all answered my question which is - export it as text and name is xls thanks again Mark On 3 September 2010 14:53, Heenan, Lambert < Lambert.Heenan at chartisinsurance.com> wrote: > If you only want to export to a single worksheet then export to a CSV file, > which is just text, but Excel will happily load it. > > Lambert > > -----Original Message----- > From: dba-tech-bounces at databaseadvisors.com [mailto: > dba-tech-bounces at databaseadvisors.com] On Behalf Of Mark Breen > Sent: Friday, September 03, 2010 3:52 AM > To: Discussion of Hardware and Software issues; Discussion concerning MS > SQL Server > Subject: [dba-Tech] Exporting to Excel when Excel is not installed > > Hello All, > > I have a server running a DotNetNuke application. > > I want to export data to Excel format from a sql source. I can write a DLL > to do that, but I suspect that if Excel is not installed on the box, it will > not work. Is that so? > > If I uploaded some of my Excel DLL's would it work then? > > The db is SQL Express so I suspect I cannot use SSIS - which is a pity. > > It is running in a shared hosting environment and I have what I think is > named "Medium Trust" privillages. AFAIK, this means that I would not be > able to run an Exe on the box. > > I can schedule a DLL to be executed however through the in built scheduling > too. > > any thoughts on how to achieve this? > > Currently I am learning towards writing to a text file and naming is > data.xls which will trick excel into opening a text tab delimited file. > > Any better ideas? > > Thanks > > Mark > _______________________________________________ > dba-Tech mailing list > dba-Tech at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-tech > Website: http://www.databaseadvisors.com > > _______________________________________________ > dba-Tech mailing list > dba-Tech at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-tech > Website: http://www.databaseadvisors.com >