为啥我插入access数据库有问题

string connectionString = ConfigurationManager.AppSettings["ConnectionString"];
        string sql = "insert into times(time) values('" + DateTime.Now + "' )";
        OleDbConnection con = new OleDbConnection(connectionString);
        OleDbCommand cmd = new OleDbCommand(sql, con);
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();

报错 string sql = "insert into times(time) values('" + DateTime.Now + "' )";
有错误，但是我在ACCESS数据库里面就没问题

---

string sql = "insert into times(time) values('" + DateTime.Now + "' )";

程序里面的格式与数据库里的格式是不相同的,要转下,

---

string sql = "insert into times([time]) values(#" + DateTime.Now + "# )";
试试

---

values('" + DateTime.Now + "' )";

---

string sql = "insert into times([time]) values(#" + DateTime.Now + "# )";