date conversion

[Guest]

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

 

[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

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

 

[Guest]

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

 

[Guest]

I got it working finally, thanks for your help

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