Microsoft KB Archive/230593

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

Article ID: 230593

Article Last Modified on 1/9/2007

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q230593





Novice: Requires knowledge of the user interface on single-user computers.



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.



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



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

1/1/1999

-or-

Jan 1, 1999

You can also resolve this problem by downloading the update discussed in the "Status" section of this article.



STATUS
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:

231408 ACC2: Access 2.0 Two-Digit Date Update Available in Download Center



MORE INFORMATION
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:

75455 ACC2: Years Between 00 and 29 Are Interpreted as 1900 to 1929

Additional query words: pra Y2K year date text import kb2000

Keywords: kbbug kbfix KB230593

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.