' *** These would go into a include file, they are actually the ADO constants that you can't use ' from the asp page Dim adVarChar Dim adParamInput adVarChar = 200 adParamInput = 1
Set cn = Server.CreateObject("ADODB.Connection") cn.Open "DSN=Example", "sa", ""
set cmd = Server.CreateObject("ADODB.Command") cmd.CommandText = "INSERT INTO tblUserName Values (?)" cmd.Parameters.Append cmd.CreateParameter("UserName", 200, 1, 35, Request.Form("YourName")) cmd.ActiveConnection = cn
Database Code 
ASP.NET Export to Excel and Word using VB.NET and C#
