php - MS Access: How does one insert NULL into DateTime field - Stack Overflow

Try the following. It works for me: INSERT INTO sometable ( somedate, somethingelse ) SELECT Null AS Expr1, "foo" AS Expr2; Basically, you are wrapping the null in the select query and letting SQL figure out how to represent it to the insert.

stackoverflow.com