Problem with date when importing

[ds_8805]

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.

[Rainlover]

You need DateTime.

Then change the format to whatever you want.

[ds_8805]

I have used DateTime datatype. However it still does not work

[Rainlover]

What format you you have?

[ds_8805]

actually I just managed to solve this problem..I realised I din set the format properly. Thanks for ur help.

[Rainlover]

Glad you got it.