ACC: You Cannot Export Dates with a Year Later Than 2078 to Microsoft Excel (212738)


The information in this article applies to:

  • Microsoft Access for Windows 95 7.0
  • Microsoft Access 97
This article was previously published under Q212738
Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

When you export a Microsoft Access table that has a date with a year later than 2078 in a Microsoft Excel format, the export works. However, there will be a null in the date field, and an export_errors table is generated in the database.

CAUSE

The low end of the operational date range for Jet 3.5 is the year 200 and the high end of the operational date range is the year 2038. Although you can enter dates with years outside of this range, some Jet functionality may provide incorrect results. Non-native Jet database formats, particularly ODBC sources, may or may not support dates outside of the range of Jet. When dates outside of the date range are not supported, imports and exports may fail, records that have dates outside of the specified range may be deleted, or incorrect results may be returned from queries for dates outside of the specified range.

RESOLUTION

Use either of the following methods to work around this behavior.

Method 1

Save the file as formatted when you export the file as an Excel file type.

To do so, when you export the file, click to select the Save As Formatted check box, and then click Export.

Method 2

Export the file as a text file. To do so:
  1. In the Save As/Export dialog box, set the Save As Type box to Text Files, and then click Export.
  2. In the Import/Export Text Wizard, click to select the Delimited or Fixed Width text box, and then click Next.
  3. Click Advanced.
  4. Click to select the Four Digit Years check box, and then click OK. Click Finish.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Access 2000.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open the sample database, Northwind.mdb.
  2. Open the Employees table in Datasheet view.
  3. Change the Hire Date on the first record to 01/01/2080. Close the table.
  4. In the Database window, click the Employees table.
  5. On the File menu, click Save As/Export.
  6. Click To an External File or Database, and then click OK.
  7. In the Save As dialog box, set the Save As Type box to Microsoft Excel 97, and then click Export. Note that a new table appears in the table list, named Employees_ExportErrors.
Modification Type:MajorLast Reviewed:10/22/2003
Keywords:kbbug kbpending KB212738
©2003 Microsoft Corporation. All rights reserved.