I am still having problems with this.
I have a date as a String working in my program, but I want to change that String, in a different class, to an sql date so that I can store data to the database using this date.
this is my code so far which seems to go through the insert block all the time.
my database worked with column_1 set as varchar and I could store the date as a string, but i changed the database to a long date, which outputs on the database as 12 May 2007.
I am converting my String to an sql date which outputs as 2007-05-12.
could you help me out with this problem, so that I can store an sql date in MS Access so that my database can work?