VB INSERT INTO 语句的语法错误。
conn.Execute("insert into [paike](grade,class,day,jieci,lession_name,teacher_id) values(" & cii_grade.ToString & "," & cii_class.ToString & "," & P_TIMES.ToString & "," & P_WEEKS.ToString & ",'" & rpaike.Fields(1).Value & "'," & rpaike.Fields(1).Value & ")")
总是这句话报错，为什么呢？
[解决办法]
如果传的值都是字符串的话
改成
conn.Execute("insert into [paike](grade,class,day,jieci,lession_name,teacher_id) values('" & cii_grade.ToString & "','" & cii_class.ToString & "','" & P_TIMES.ToString & "','" & P_WEEKS.ToString & "','" & rpaike.Fields(1).Value & "','" & rpaike.Fields(1).Value & "')")
[解决办法]
把语句拼接后的结果抓出来调试，就知道哪里出了什么问题。
[解决办法]
少了SQL语句中字符串的引号"'"
