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")
%>