can't insert a date to table
i work with ado and access 2000
i use INSERT INTO command and all the fields get into the table but
the one with the address format ,it makes an error and wont get into
the table .is there any limit about the format of text that i can use?
this is the insert line i use:
"INSERT INTO nots(branchname ,date, nots1, nots2 ) " _
& " VALUES ('xxxx', '24/4/2001', 'xxxx','xxxx' );"
the fileds in access defined once as text and the other time as
'date/time ' both failed to eccept the date value