ACC2: All Two-Digit Dates Imported from Text Resolved in 1900s

When you import data from a text file into Microsoft Access, dates that contain years with two digits are always interpreted as years between 1900 and 1999.

Microsoft Access 2.0 does not interpret two-digit years between 00 and 30 as years between 2000 and 2030.

When you import data from a text file, ensure that all the date values use a format with a four-digit year. For example: You can also resolve this problem by downloading the update discussed in the "Status" section of this article.

Microsoft has confirmed that this is a problem in Microsoft Access 2.0. This problem is resolved by the Microsoft Access 2.0 Date Update.

To obtain the update, please see the following article in the Microsoft Knowledge Base:

Microsoft Access 2.0 assumes that all imported two-digit dates are between 1900 and 1999. For more detailed information on two-digit dates and Access 2.0, see the following article in the Microsoft Knowledge Base: