Article ID: 223225 - View products that this article applies to.
This article was previously published under Q223225
Novice: Requires knowledge of the user interface on single-user computers.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
When you export a table that contains a date earlier than 01/01/1900 to Microsoft Excel, you may encounter one of the following problems:
Microsoft Excel does not recognize dates earlier than January 1, 1900.
Exporting date values earlier than 1/1/1900 to Excel always causes the fields that contain unrecognized dates to be blank. However, you can avoid the errors that you receive when you export from an Access project by upgrading to SQL Server 7.0 or Microsoft Data Engine to Service Pack 1.
For additional information about downloading the latest service pack, please see the following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/301511/EN-US/ )INF: How to Obtain the Latest SQL Server 7.0 Service Pack
Steps to Reproduce Behavior in an Access Database
Contact us for more help
Connect with Answer Desk for expert help.