代码如下:
Public Sub Insert()
  SqlStmt = "INSERT INTO Wages (EmpId,EmpName,Year,Month,Jibengz,Gangweigz,Jibiegz,Gonglinggz,Teshugzbt,Gongqinzujb,Chuchaibt,Sijijsbt,Zhiwugz,Baoanhuoshibt,Leijijbgz,Heji,Sxjhjkc,Sfje) Values(" _
     + Trim(EmpId) + ",'" + Trim(EmpName) + "'," + Trim(Str(Year)) + "," + Trim(Str(Month)) + "," + Trim(Str(Jibengz)) + "," + Trim(Str(Gangweigz)) + "," _
     + Trim(Str(Jibiegz)) + "," + Trim(Str(Gonglinggz)) + "," + Trim(Str(Teshugzbt)) + "," + Trim(Str(Gongqinzujb)) + "," + Trim(Str(Chuchaibt)) + "," _
     + Trim(Str(Sijijsbt)) + "," + Trim(Str(Zhiwugz)) + "," + Trim(Str(Baoanhuoshibt)) + "," + Trim(Str(Leijijbgz)) + "," + Trim(Str(Heji)) + "," + Trim(Str(Sxjhjkc)) + "," + Trim(Str(Sfje)) + ")"MsgBox SqlStmt  SQLExt (SqlStmt)
End SubWages表有:Id,EmpId,EmpName,Year,Month,Jibengz,Gangweigz,Jibiegz,Gonglinggz,Teshugzbt,Gongqinzujb,Chuchaibt,Sijijsbt,Zhiwugz,Baoanhuoshibt,Leijijbgz,Heji,Sxjhjkc,Sfje
这些字段,Id类型为自动编号、EmpName为文本类型,其它字段为数字类型,数据库为access2003我弄这个弄了两天,请好心的大虾指点下,谢谢

解决方案 »

  1.   

    MsgBox SqlStmt 的输出是什么?
      

  2.   

    把你的SqlStmt拿到数据库中去调试一下看看
      

  3.   

    INSERT INTO Wages(EmpId,EmpName,Year,Month,Jibengz,Gangweigz,Jibiegz,Gonglinggz,Teshugzbt,Gongqinzujb,Chuchaibt,Sijijsbt,Zhiwugz,Baoanhuoshibt,Leijijbgz,Heji,Sxjhjkc,Sfje) 
    Values(21,'111',2006,12,11,11,11,11,11,11,11,11,11,11,11,11,11,11)这是msgbox的输出请问楼上的,怎样把SqlStmt拿到数据库去调试?