See this Microsoft kbase
EXAMPLE WHERE WE CREATED THE POSTING FORM WITH CODE:
If you need to create the form to post the data using scripting, here is an example:
<%
Response.write "<FORM action=" & """excel.asp""" & "id=form1 method=post name=form1>"
Response.write "<INPUT type =" & """hidden""" & "id= " & """strsql""" & " name=" & """strsql""" & " value=""" & strsql2 & """>" Response.write "<INPUT type =" & """hidden""" & "id= " & """database""" & " name=" & """database""" & " value=""" & strDBSource & """>" Response.write "<INPUT type=" & """submit""" & "value=" & """Export to Excel""" & ">" Response.write "</FORM>" %>
On the receiving page (in the example, above, on the excel.asp page), do this:
At top of page (before anything else)
<%@ Language=VBScript %>
In body section:
<%
Dim strsql2 strsql2 = Request.Form("strsql") Dim database database = Request.form("Database") %> |
ASP >