insert 语句
SQL = "insert into newcard(cardnumber,sno,sname,grade,department,money,tel) values ('" & Trim(Text1.Text) & "','" & Trim(Text2.Text) & "','" & Trim(Text3.Text) & "','" & Trim$(Text4.Text) & "','" & Val(Text5.Text) & "','" & Trim$(Text6.Text) & "','" & Trim$(Text7.Text) & "');"conn.Execute SQL
在sql里就可以插 进去,但是在插入access2000时就提示insert into 语法有错误
请问我哪里错了?