asp中数据输入access,在留言本中

我怎么试都不行呀！！高手教我！！！

<%

dim name,email,note,conn

name =request.form("name")

email =request.form("email")

note =request.form("note")

%>

<%

dim exec

'exec="insert into data(name,email,note) values('"+name+"','"+email+"','"+note+"')"

'exec="insert into data(name,email,note) values("+name+","+email+","+note+")"

'exec="insert into data(name,email,note) values('+name+','+email+','+note+')"

exec="insert into data(name,email,note) values('"name"','"email"','"note"')"

'exec="insert into data(name,email,note) values(name,email,note)"

'exec="insert into data(name,email,note) values('name','email','note')"

set conn=server.createobject("adodb.connection")

conn.open "provider=microsoft.jet.oledb.4.0;data source="&server.mappath("data.mdb")

conn.open "driver={microsoft access driver (*.mdb)}; dbq="&server.mappath("data.mdb")

conn.execute exec

'set rs=Server.CreateObejct("ADODB.Recordset")

'sql="select * from data "

'rs.open sql,conn,2,3

'rs.addnew

'rs("name")=name

'rs("email")=email

'rs("note")=note

'rs.update

'rs.close

'set rs=nothing

conn.Close

set conn=nothing

%>

只有重建一个了．