Forums
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...
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 <body><img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>
<% Response.ContentType = "application/vnd.ms-excel" %>
Regards
Vince
Visit my home: www.chez-vince.com
VBScript | ASP | HTML | SQL | Oracle | Hosting
<% Response.ContentType = "application/vnd.ms-excel" %>
Regards
Vince
Visit my home: www.chez-vince.com
VBScript | ASP | HTML | SQL | Oracle | Hosting