急、在线等解决问题、、、、、
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("dfff.mdb")
name_t=request.Form("name")
phone_t=request.Form("phone")
if name_t ="" or phone_t="" then
else
KeMu_t=request.Form("KeMu")
sex_t=request.Form("sex")
month_t=request.Form("month1")+request.Form("month2")
xueli_t=request.Form("xueli")
sfzhm_t=request.Form("sfzhm")
txdz_t=request.Form("txdz")
mail_address_t=request.Form("mail_address")
email_t=request.Form("email")
textarea_t=request.Form("textarea")
sj=date()
exec="insert into dftt values('"&KeMu_t&"','"&name_t&"','"&sex_t&"','"&month_t&"','"&xueli_t&"','"&sfzhm_t&"','"&txdz_t&"','"&mail_address_t&"',"&email_t&",'"&textarea_t&"','"&sj&"')"
conn.execute exec
end if
conn.close
set conn=nothing
sj=date()
response.write "您的信息已经提交成功!"
%>
出错信息:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。