ACC95: Two-Digit Dates Not Interpreted Correctly Importing Data from Text Files

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q75458

Expand all | Collapse all

SYMPTOMS

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.

Back to the top

CAUSE

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

Back to the top

RESOLUTION

When you import data from a text file, ensure that all the date values use a format that includes a four-digit year. For example:

1/1/1999

-or-

Jan 1, 1999

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Back to the top

APPLIES TO

Microsoft Access 95 Standard Edition

Back to the top

kbbug kbpending KB75458

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top