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

• Microsoft Access 7.0

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

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 

Last Reviewed: July 2, 1999