importing dates (problem)

[Guest]

I'm trying to import a excel file which has a date column
in the following format: dd/mm/yy (16/12/06) when importing
the file to access the date is stored as 12/06/2016.

Is there an easy way to get the date in the correct format
as the date is formatted in the excel file?

Thanks.

 

[Jeff Boyce]

Eric

Access stores date/time values as a special floating point number (the
'whole' number is the number of days since late in the 1800's, the decimal
fraction is the portion-of-day, i.e., time -- .5000 = noon).

How you have Access format the date/time data is up to you. You can control
this at the table definition level, or, more appropriately, in your forms
and reports.

Regards

Jeff Boyce
Microsoft Office/Access MVP