JDBC Date Issues

[minkusz]

I am having trouble inserting a date value into an Access DB using JDBC. My Access field is of type Date/Time, with short date format. All my references say to use the java.sql.Date class to do this. Is this conflicting with using the Short Date format in Access? I have tried almost every variation I can think of. Please help.

insert into rest_totals (name,Service_Charges,Tickets,Net_Sales,Total_Sales,Date) VALUES ('Baoding',2, 5,182.33,200.00,'2001-08-14')

After getting to this point once I started over, coding and testing field by field, to find out where the error was. Everything worked fine until I added the Date field. Any suggestions?

 

[Databaseguy]

Have you tried ('Baoding',2, 5,182.33,200.00,#2001-08-14#)
Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[minkusz]

I tried this and I get the same result. An exception is thrown saying I have a syntax error in my insert into statement. Either way, thanks for your input.

 

[Guest_imported]

Rename your some of the column names like "name"&"Date" as to some other names " cus_name" ,"today_date"...