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.
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename=userlist.xls"
Dim Database, i
Set Database = ConnectDB()
Dim rsUserEmails, UserEmails
UserEmails = Empty
Set rsUserEmails = Database.Execute("SELECT * FROM Users")
Do Until rsUserEmails.EOF
... data here ...
Set rsUserEmails = Nothing