Hello! I am trying to import an excel file to access. I have managed to
import successfully. However, my date column is in the excel spreadsheet
which looks as such eg 4-Feb-09 is changed to 4/2/09 in access after it has
been imported. I have
tried to keep the date's column as text datatype or datetime datatype. But
both does not work. Hope someone could clear my doubt. Thks!! Any help is
appreciated.

Do you live somewhere that uses DD/MM/YYYY date format or the MM/DD/YYYY
format used mostly in the USA? The Window's Regional Settings on your PC can
make a difference.

Usually keeping the field as Text in a temporary is one way to get in the
data correctly. Then you can use things like IsDate, CDate, DatePart, etc. to
get the from the temp table to the final table.

What happens when you link to the Excel spreadsheet instead of importing it?
You might have better luck with the date format that way.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"ds" wrote:

> Hello! I am trying to import an excel file to access. I have managed to
> import successfully. However, my date column is in the excel spreadsheet
> which looks as such eg 4-Feb-09 is changed to 4/2/09 in access after it has
> been imported. I have
> tried to keep the date's column as text datatype or datetime datatype. But
> both does not work. Hope someone could clear my doubt. Thks!! Any help is
> appreciated.