Eine Einführung in

SQL

Can't insert data because of incompatable formats.

MS Access
If the data inserted is of the wrong type the insert may fail. Because the date format may depend on the local settings this may cause confusion. Using a 4 digit year and a three character month works for most systems (in English speaking regions).	Execute tidy up code silently DROP TABLE t_x CREATE TABLE t_x (x VARCHAR(5), y DATETIME); INSERT INTO t_x VALUES ('abcdef', NULL); INSERT INTO t_x VALUES ('ambig', '10-11-12'); INSERT INTO t_x VALUES ('unamb', '10 Nov 2012'); SELECT * FROM t_x
Specific to MS Access
The string 'abcdef' is accepted but truncated. The date '10-11-12' is accepted (as UK format).