Java + MS Access

[Damo_Suzuki]

I'm trying to insert dates from a JTextField onto an Acess database. It refuses to enter the date correctly , it either goes in as some garbage like "1.234756425" or "1993"

Can anyone help please? its driving me insane

[Damo_Suzuki]

The code is something like this

connection code here



Calendar cal = Calendar.getInstance();
Date today = cal.getTime();
SimpleDateFormat fmt =new SimpleDateFormat("MM-dd-yyyy");
String todayStr = fmt.format(today);

executequery("insert into table values("+todayStr+","+othervalue+")";

[me_code2004]

Well, if you already have debug your code then if the todayStr is holded the value that you wanted (a string value with a date format) than are you sure that the data type of your Access database field is also a date data type (ex: your field name is fldTodayDate and the data type is DateTime) ?