sql = "select * from ta where leibie = '"&leibie&"' and proName = '"&proName&"' and cangku = '"&cangku&"'"
rs.open sql,conn,1,3
if rs.bof and rs.eof then
rs.addnew
rs("字段")=值
rs.update
else
rs("字段")=值
rs.update
end if
sql = "select * from ta where leibie = '"&leibie&"' and proName = '"&proName&"' and cangku = '"&cangku&"'"
rs.open sql,conn,1,3
if rs.bof and rs.eof then
'//添加
else
'//修改
end if