date conversion

V

vicky

Im trying to import a table from excel into access, but for my date field I
keep on getting weird numbers instead of dates. For example, instead of
1/1/02 it would say 3804. Anybody knows how I can fix it?
Thanks
 
C

Chriske911

Im trying to import a table from excel into access, but for my date field I
keep on getting weird numbers instead of dates. For example, instead of
1/1/02 it would say 3804. Anybody knows how I can fix it?
Thanks
Click to expand...

the values you see are the numeric value of a date field instead of the
display value
you could explicitly format that column in excel as a date/time field
or you can again do the same thing during the import
there is a window during the import wizard where you can assign a
format to an imported column

grtz
 
V

vicky

I tried formating the date column in excel as date/time field and i also
tried doing th same thing in access but it still doesnt work
 
V

vicky

I got it working finally, thanks for your help

vicky said:
I tried formating the date column in excel as date/time field and i also
tried doing th same thing in access but it still doesnt work
Click to expand...
 
Top