Microsoft KB Archive/212738

= ACC: You Cannot Export Dates with a Year Later Than 2078 to Microsoft Excel =

Article ID: 212738

Article Last Modified on 1/24/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



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.



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.

Additional query words: pra excel dates year acc97 xl97 acc95 xl95 xl

Keywords: kbbug kbpending KB212738

-

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

© Microsoft Corporation. All rights reserved.