Question

向access添加数据时提示“insert into”用法错误

我是个新手，向access添加数据时提示“insert into”用法错误，请求帮助！！
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\mydata.mdb");
OleDbCommand comm;
try
{

comm = new OleDbCommand();
comm.Connection = conn;
conn.Open();
comm.CommandText ="INSERT INTO User([UserNum],[Password],[Path]) VALUES ('"+txtUser.Text+"','"+txtPassword.Text+"','"+txtPath.Text+"')";
comm.ExecuteNonQuery();

}
finally
{
conn.Close();
}

Answer 1

INSERT INTO User中的User是access的关键字，改为INSERT INTO [User]