[dba-Tech] Exporting to Excel when Excel is not installed

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