Dates change when imported from Excel

[Sharon Dulcich]

When I Import data from Excel to Access SOME of the dates
change to a plain number. If the date is prior to 1900 the
date remains as it was. However, if the date is after
1900, it is changed to something like 8, or 356, or 1990.
I cannot find the correct place to fix this. I am working
with records from the late 1800's to the very early
1900's. Is this an Access problem or an Excel problem?

Sharon

 

[Joe Fallon]

It is a combined problem.
You should force Access to guess the datatype as TEXT, not Date/Time or
Number.
Do this by putting 'ABC in the first row of data in the Date column.

Then import the data to a staging table.
Then use Access format function in queries to send the data to the real
table.