can't store a date in Access database
24 Oct
2001
24 Oct
'01
9:47 p.m.
Hello, This is the error the is troubling me: Error Type: sql.error Error Value: ('37000', -3502, '[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.') My SQL statement: insert in TableName (Date) values ("10/24/2001") I have tried at least a dozen different date formats including the wierd '#' delimiters. Anyone solve this problem? Micah ---------------------------------------------------------------------------- -- Micah Martin Software Engineer Object Mentor, Inc. micah@objectmentor.com www.objectmentor.com, www.xprogramming.com www.pairprogramming.com, www.junit.org
8930
Age (days ago)
8930
Last active (days ago)
0 comments
1 participants
participants (1)
-
Micah Martin