date/time problems

[Dimension]

i have a table field in the format dd/mm/yyyy.

i only want to store the date in that format, no time in there but i cant make the time go away using access in visual studio. can anyone help?

 

[JohnH]

A Date always contain a Time part, if you mean you want to reset the time part for all dates then use the Date property of the Date instance, the time value set to 12:00:00 midnight (00:00:00).

Dim d as Date = Date.Now 'current date and time
d = d.Date 'current date only, time is set to 0

 

[Dimension]

thanks. i have also ran into the problem of importing a csv file. i am getting errors in to specific fields.

the first is a date which in the csv file as dd/mm/yyyy and the other is a picture field which i think is in blob format because there are lots of characters in it. i have set the data type of the table as 'image' which doesnt seem to work.

the error i get looks like this:

bulk load data conversion error (type mismatch or invalid character for the specified codepage)....