The MSDN KB article 189198
(http://support.microsoft.com/default.aspx?scid=kb;en-
us;189198) describes how to create a spreadsheet with info
from a database. Is there a way to create the spreadsheet
on the users computer instead of on the web server? I want
to prevent a whole lot of xls files from being created and
stored on the server.

Create the XLS as described in the article, then stream it to the client.

http://www.darkfalz.com/Scripts_Details.aspx?pstID=1098

Chris

"Luis" <andyza@webmail.co.za> wrote in message
news:1ce701c46fbf$a0c6b430$a601280a@phx.gbl...[color=blue]
> The MSDN KB article 189198
> (http://support.microsoft.com/default.aspx?scid=kb;en-
> us;189198) describes how to create a spreadsheet with info
> from a database. Is there a way to create the spreadsheet
> on the users computer instead of on the web server? I want
> to prevent a whole lot of xls files from being created and
> stored on the server.
>[/color]

You can actually skipped the whole ADODB.Stream part as in this case the OP
doesn't want to create any files on the server. Just output an HTML table
and change the ContentType to Excel:

http://support.microsoft.com/?kbid=301044

--
Tom Kaminski IIS MVP
http://www.microsoft.com/windowsserv...y/centers/iis/
http://mvp.support.microsoft.com/
http://www.iisfaq.com/
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://www.tryiis.com


"CJM" <cjmnews04@newsgroups.nospam> wrote in message
news:uUxFsU8bEHA.2352@TK2MSFTNGP09.phx.gbl...[color=blue]
> Create the XLS as described in the article, then stream it to the client.
>
> http://www.darkfalz.com/Scripts_Details.aspx?pstID=1098
>
> Chris
>
> "Luis" <andyza@webmail.co.za> wrote in message
> news:1ce701c46fbf$a0c6b430$a601280a@phx.gbl...[color=green]
> > The MSDN KB article 189198
> > (http://support.microsoft.com/default.aspx?scid=kb;en-
> > us;189198) describes how to create a spreadsheet with info
> > from a database. Is there a way to create the spreadsheet
> > on the users computer instead of on the web server? I want
> > to prevent a whole lot of xls files from being created and
> > stored on the server.
> >[/color]
>
>[/color]