How do I do this?

[Kevin Audleman]

I am storing user entered form data from an ASP page in a MSSQL 2000
database. I would like to give my administrators a way to download a
tab file with the entries. Is writing an ASP page the best way to do
this? And if so, how can I convert database records into a file that
will download through the browser?

Thanks,
Kevin

 

[Evertjan.]

Kevin Audleman wrote on 01 mei 2006 in
microsoft.public.inetserver.asp.general:

I am storing user entered form data from an ASP page in a MSSQL 2000
database. I would like to give my administrators a way to download a
tab file with the entries. Is writing an ASP page the best way to do
this?

It is a very good way. Discussion of "the Best" is not usefull, methinks.

And if so, how can I convert database records into a file that
will download through the browser?

Just response.write the text in an asp-file without the html elements.

When using VBscript [Jscript is also possible], use:

vbTab
vbCrLf

and loop through the records, adding the required fields.

It can be downloaded by the browser as window content.
If you mean downloading to a file, rightclick+"save as ..." the link.

You could set the filetype:

<%
Response.AddHeader "Content-Type", "application/x-unknown"
%>

forcing a download to file.