you can do it like this


<%
set con= server.CreateObject("adodb.connection")
set rs = server.CreateObject ("adodb.recordset")

con.Open  "dsn=dsnname;uid=userid;pwd=password;"
str="truncate table TName"
rs.Open str,con
%>
<%
str1= "insert into Tname values(x , y)
rs.open str1,con

rs.close
set rs= nothing
con.close
set con =nothing
%>

put appropraite values at the right places and execute.

Vinay