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

Hi Mark:

I have never tried to move an Excel spread sheet into DNN. Without full SSIS
capabilities you would need an app to simulate the spreadsheets importing
feature... There are numerous listed...of course you could always roll your
own.

I do not think the placing of an Excel dll will do anything as this is a
website. As well to do anything major you would need full access to the
site. It would have to be something like an IIS plug-in as your DB does not
have extended import features.

If I find something I will post it here.

Jim

   

-----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 12: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