File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes inserting a date in MS Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "inserting a date in MS Access" Watch "inserting a date in MS Access" New topic

inserting a date in MS Access

anupama rc

Joined: Mar 01, 2001
Posts: 3
hi freinds
i am doing this servlet program where i have to insert dates into a data base...i accept the date as a string ...convert into Date object ...but when i try toinsert into the data base ...its giving me an error saying Syntax error (operator missing)..
I have converted the string into date object using SimpleDateFormat class...and its parse mtd
pls help


Joe Paolangeli
Ranch Hand

Joined: Apr 05, 2000
Posts: 73
When creating the date object for the insert try using java.sql.Date instead of java.util.Date
I agree. Here's the link:
subject: inserting a date in MS Access
It's not a secret anymore!