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!