Question

求帮助，VB在插入access表时提示 INSERT INTO 语句的语法错误

Dim cnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=g:\password.mdb;Persist Security Info=True"
Dim cn As OleDb.OleDbConnection = New OleDb.OleDbConnection(cnstr)
cn.Open()
Dim sqlstr = "insert into password(名称,网址,用户名,密码,备注) values (“1”,“1”,“1”,“1”,“1”)"
Dim cmd As New OleDb.OleDbCommand(sqlstr, cn)
cmd.ExecuteNonQuery()
cn.Close()
在线等，求帮助

Answer 1

注意1
有的地方一定用空格分隔!
数据表名称与后面那个括号之间,要空格!
注意2
字符串常量用单引号引起来!
"insert into password (名称,网址,用户名,密码,备注) values ('1','1','1','1','1')"

Answer 2

values (“1”,“1”,“1”,“1”,“1”) 这里面的双引号换成单引号