ASP SQL: INSERT problem help!

[david2006]

Hi,

I have one problem to insert values into a table. These values are selected from another table. my codes are the following:

st=Request("stat")
du=Request("dur")

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "C:/dwmxweb/D1/nBase.mdb"
set rs = Server.CreateObject("ADODB.recordset")

sql2= "INSERT INTO PDF SELECT * FROM ResearchAssistants WHERE Status =" & "'" & st & "'" & " " _
& "AND Semester=" & "'" & du & "'"

My purpose is to display all data in database called PDF after above insertion from the other table, but this insert looks no working.

Thanks!