Dim cn1 As New ADODB.Connection
cn1.Open "Data Source=" & App.Path & "/db2.mdb;Provider=Microsoft.Jet.OLEDB.4.0"cn1.Execute "insert into test(name,password) values('kk','kk')"
提示说insert into的语法错误!
郁闷啊!
cn1.Open "Data Source=" & App.Path & "/db2.mdb;Provider=Microsoft.Jet.OLEDB.4.0"cn1.Execute "insert into test(name,password) values('kk','kk')"
提示说insert into的语法错误!
郁闷啊!
你直接用insert into test values('kk','kk')
看看这样有没有错误
同样的错误,我用的是ACCESS2000。用AddNew可以插入数据。为什么用“INSERT ITNO”会有语法错误啊??:(
谢谢大家帮助!