I'm trying to create an easy way for end users to get an excel
spreadsheet with data from a SQL Server database. I can easily do this
myself with DTS through Enterprise Manager but then I have to be
involved each time the user requests updated data. Is this a simple
thing to do? I'm using ASP (not ASP .net) and SQL Server 2000. Thanks
in advance.

look at http://support.microsoft.com/kb/q189198/ or change the MIME type

http://sqlservercode.blogspot.com/



"Christian Duffett" wrote:

DTS may not be the best way forward here. You may be better off using
Excel automation through ASP.Net. Difficult to say without more info.

Allan

"Christian Duffett" <duffett (AT) gmail (DOT) com> wrote

Using ASP, you can use this at the top of your asp page.

<%
Response.ContentType = "application/vnd.ms-excel"
%>

The query result will be rendered in XL format.

"Christian Duffett" wrote:

I actually found a real clean way to do it here
http://support.microsoft.com/kb/q189198/

i made a couple changes so that I wouldn't have a bunch of random files
on the webserver though and added
<% Response.ContentType = "application/vnd.ms-excel" %>
at the top and instead of writing to the file simply had
response.write's. If anyone else wants more info let me know.

With a Excel automation you must install a Excel Server Component.

Why dont'you try to create a SYLK file format ?
They are several articles on the web which described this format.

Else you can create a XML spreadsheet.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> a écrit dans le message de news:
urdlSgC0FHA.2884 (AT) TK2MSFTNGP09 (DOT) phx.gbl...