Nope I tried the complete date format also. It is inserting a row but it
catches SQLException.
At 08:42 PM 11/10/00 +0100, Neil Burnett wrote:
>SQL dates need to be in the format #mm/dd/yyyy# irrespective of the column
>format. Access has only one data type for date and that is date.
>
>Just do a query on dates in Access itself and then look at the SQL it
>creates. That will show you the syntax. This is all SQL, not just Access SQL.
>
>E.g. SELECT * FROM MyTable WHERE ADate = #11/10/2000#
>
>Regards
>
>Neil
>
>At 11:19 10/11/2000 -0700, unni wrote:
> >Hello,
> >
> >When I am trying to insert a date into MS Access database I am getting an
> >error saying 'Data Type mismatch in criteria expression".
> >I have the column as 'small date mm/dd/yy' format and I am inserting in the
> >same format. Did any one have this problem before?
> >
> >Thanks.
> >-Unni
> >
> >___________________________________________________________________________
> >To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> >of the message "signoff SERVLET-INTEREST".
> >
> >Archives: http://archives.java.sun.com/archives/servlet-interest.html
> >Resources: http://java.sun.com/products/servlet/external-resources.html
> >LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
>
>___________________________________________________________________________
>To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
