Insert SQL command with Datetime in MS-Access

by

Date & Time input in access use #, since access can’t do auto conversion from char/text into date or time in SQL Query (or access call it query), and you better use international standard for inputting date time which was YYYY-MM-DD HH:NN:SS (4-digit year, 2-digit month, 2-digit day, 2-digit hour, 2-digit minute, 2-digit second)

so for 4/21/2009 2:25:53 PM use #2009-04-21 14:25:53#

or if it still fail, you can use #’2009-04-21 14:25:53’#

Edit: Above might be working if you enable ANSI 92 or using ADO/OLEDB as database interface, thanks David for pointing out

I suggest you use YYYY-MM-DD HH:NN:SS format and try it with single quotes (‘) before use # like i said above

More Related Contents:

  1. Access 2007 – Left Join to a query returns #Error instead of Null
  2. Save password for ODBC connection to MS SQL server from MS Access 2007
  3. Access 2007 – INSERT and instant SELECT doesn’t retrieve the inserted data
  4. Trouble with InputBoxes
  5. ms access vba code for update records through form
  6. How do i add percentage an Access query?
  7. How does one decompile and recompile a database application?
  8. What are the rules governing usage of parenthesis in VBA function calls?
  9. Code to loop through all records in MS Access
  10. create form to add records in multiple tables
  11. How do I force VBA/Access to require variables to be defined?
  12. Why is my query not updateable?
  13. Is it possible to create a recursive query in Access?
  14. VBA: Difference in two ways of declaring a new object? (Trying to understand why my solution works)
  15. What is the equivalent of Select Case in Access SQL?
  16. Is it better to use ADO or DAO in Access 2007?
  17. How do I access the selected rows in Access?
  18. How do I execute multiple SQL Statements in Access’ Query Editor?
  19. VBA procedure to import csv file into access
  20. how to show query results in a datasheet in the same form?
  21. Selecting 2 tables from 2 different databases (ACCESS)
  22. connected combo boxes in continuous form – the second combo doesn’t show its value if dependent on first combo how could I fix that
  23. Linked table ms access 2010 change connection string
  24. Null values for variables in VBA
  25. MS Access query returning Chinese characters – possible table corruption?
  26. Using a centralized VBA module in multiple Access databases
  27. How to execute a query in ms-access in VBA code?
  28. How to add a menu item to the default right click context menu
  29. Force all users to disconnect from 2010 Access backend database
  30. Check if access table exists

Leave a Comment