Exporting pre-1900 dates to Access

[Jim J.]

I have a large worksheet (15k items) that relate to law books, some of which
were published during the mid-1800's. I am trying to export this data from
Excel into Access.

The columns are formatted as date/time in Excel (mm/dd/yyyy). When I import
them into Access using the import wizard, Access does properly recognize the
field as a date format.

However, Access does not seem to recognize pre-1900 as a valid date, and
inserts a null value for that field for any record that was published prior
to 1/1/1900. Any record that was published on 1/1/1900 or later is formatted
perfectly.

An Access MVP suggested a few workarounds, but also suggested that I pose a
question here to see if any Excel gurus had a more streamlined idea.

Many thanks in advance!

 

[Ken Snell [MVP]]

I have a large worksheet (15k items) that relate to law books, some of
which
were published during the mid-1800's. I am trying to export this data
from
Excel into Access.

The columns are formatted as date/time in Excel (mm/dd/yyyy). When I
import
them into Access using the import wizard, Access does properly recognize
the
field as a date format.

However, Access does not seem to recognize pre-1900 as a valid date, and
inserts a null value for that field for any record that was published
prior
to 1/1/1900. Any record that was published on 1/1/1900 or later is
formatted
perfectly.

An Access MVP suggested a few workarounds, but also suggested that I pose
a
question here to see if any Excel gurus had a more streamlined idea.

Many thanks in advance!

You've posted this into an ACCESS newsgroup, not an EXCEL newsgroup?