Forums

ASP

This topic is locked

export to excel

Posted 07 Oct 2003 02:08:28
1
has voted
07 Oct 2003 02:08:28 chris holloway posted:
I would like to export the results of a recordset to an excel document through ASP. Is this possible ? how ?

thanks

Replies

Replied 07 Oct 2003 06:17:16
07 Oct 2003 06:17:16 Dan Berdusco replied:
If you are using Dreamweaver, there is an extension that you can use that will do this for you. You can DL it here dmxzone.com/showDetail.asp?TypeId=3&NewsId=3907.

Hope that helps...

Replied 10 Oct 2003 13:53:13
10 Oct 2003 13:53:13 Vince Baker replied:
The way I always do this is to create a simple page with the recordset displayed in a table and add this line of code as the first line of the body of your page (just under &lt;body&gt<img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

&lt;% Response.ContentType = "application/vnd.ms-excel" %&gt;

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

Reply to this topic