See this Microsoft kbase
http://support.microsoft.com/kb/300104
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")
%>