ASP怎么插入ACCESS表数据
展开全部
<%
set conn = server.createobject("ADODB.connection")
conn.open "driver={microsoft Access driver (*.mdb)};dbq="&server.mappath("数据库文件的相对路径/A.mdb")
set rs_insert = server.createobject("ADODB.recordset")
sql = "insert into B (C) values ('"&D&"')"
rs_insert.open sql,conn,1,3
%>
set conn = server.createobject("ADODB.connection")
conn.open "driver={microsoft Access driver (*.mdb)};dbq="&server.mappath("数据库文件的相对路径/A.mdb")
set rs_insert = server.createobject("ADODB.recordset")
sql = "insert into B (C) values ('"&D&"')"
rs_insert.open sql,conn,1,3
%>
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询