Trying to export data to Excel. It's probably been four years since I've used straight ASP (vs. .NET) so I'm a bit rusty. Found several articles and forum posts with people having this same error, but no resolution on any of them.
Clicking the link to my ASP file pops up a download box, then immediately an error box that says the site cannot be found. If I remove the Excel headers, the page displays perfectly--an unformatted table of my data.
Any suggestions would be great.
Thanks
Code:
<%
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename=userlist.xls"
%>
<table>
<%
Dim Database, i
Set Database = ConnectDB()
Dim rsUserEmails, UserEmails
UserEmails = Empty
Set rsUserEmails = Database.Execute("SELECT * FROM Users")
Do Until rsUserEmails.EOF
%>
<tr>
... data here ...
</tr>
<%
rsUserEmails.MoveNext
Loop
rsUserEmails.Close
Set rsUserEmails = Nothing
%>
</table>
<%
Database.Close
Response.End
%>
dBforums
>
Error exporting to Excel
10-09-09, 22:48
Linear Mode
