importing excel dates???

[spinkung]

Hi all,

I am trying to import a sheet from excel into a new table in access. One of my columns has a date value which, when imported changes to the actual appliacation value (i.e. 1/1/2006 becomes 38718).

Is there a way to stop this happening or a function within acces that changes the value back to a date format?

Cheers,
Spinkung

 

[CoachPhil]

PDATE Your_Table_Here
SET Your_Table_Here.Date_Column = IIf(IsDate([Date_Column])=True,[Date_Column],CVDate([Date_Column]));

 

[gemma-the-husky]

are you sure there arent some rogue values in the column that are not dates.

eg text, or numbers

these may stop the column imprting correctly

 

[namliam]

A date is a number, only thing is it is actually also beeing displayed as a number... Simply change your column from Double/Integer what ever number format to a date/time field you want to have and you are done...

This usually happens if
1) Dates in excel arent actually dates
2) Sheet begins with empty cells