Microsoft KB Archive/75458

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

Article ID: 75458

Article Last Modified on 1/9/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q75458





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 7.0 does not handle 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 that includes a four-digit year. For example:

1/1/1999

-or-

Jan 1, 1999



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

Additional query words: pra Y2K year date text import kb2000

Keywords: kbbug kbpending KB75458

-

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

© Microsoft Corporation. All rights reserved.