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

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
>



More information about the dba-Tech mailing list