File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
Bookmark "inserting a date in MS Access" Watch "inserting a date in MS Access" New topic
Author

inserting a date in MS Access

anupama rc
Greenhorn

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

------------------
anu


anu
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
 
Don't get me started about those stupid light bulbs.
 
subject: inserting a date in MS Access