How can I insert date data to Access 2000?
What is the right format?
SQL Query:
INSERT INTO TBL_LOG (DATE, INFORMATION, USER, LEVEL_NUM, LEVEL_REC) VALUES ('09-08-2000', 'Some text.', 'best user', '5', '8')
Access (or PHP) gives error:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in odbc_lib.inc on line 93
