ACC95: Two-Digit Dates Not Interpreted Correctly Importing Data from Text Files |
The information in this article applies to:
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 this to be a problem in the Microsoft products listed
at the beginning of this article.
This problem no longer occurs in the Office 95 Year 2000 Update.
For more information about the Office 95 Year 2000 Update, please visit the "Year 2000 Update Fact Sheet" page at the following Microsoft Web site:
http://officeupdate.microsoft.com/Articles/o95y2kfactsheet.htm
To download the the Office 95 Year 2000 Update, please visit the following Microsoft Web site:
http://officeupdate.microsoft.com/downloadDetails/O95y2k.htm
REFERENCES
For more information about how Microsoft products are affected by year 2000
(Y2K) issues, please see the following Microsoft World Wide Web site:
http://www.microsoft.com/year2000/
Additional query words:
pra Y2K year date text import kb2000
Keywords : kbdta kb2000
Version : WINDOWS:7.0
Platform : WINDOWS
Issue type : kbbug