Microsoft KB Archive/101288
The information in this article applies to:
When you export a FoxPro database containing a DATE field to Microsoft Excel, the resulting spreadsheet contains the date as a general expression. This problem often results in an incorrect date format on the Microsoft Excel spreadsheet.
FoxPro exports data from a .DBF file as unformatted text strings.
To correct this problem, do the following in Microsoft Excel 5.0:
The date will now be in the correct format.
This behavior is by design.
Steps to Reproduce Behavior
NOTE: These steps create a spreadsheet called TESTDATE.XLS. They also assume that you are using Microsoft Excel 5.0.
Note that All is selected under Category and General is selected under Format Codes. (Date would be selected under Category if the cell was formatted as a date field.) Additional query words: spread sheet tshoot
Keywords : kbinterop FoxDos FoxWin FxinteropSpread KBQ Version : MS-DOS:2.0,2.5,2.5a,2.5b,2.6,2.6a; WINDOWS:2.5,2.5a,2.5b,2.6,2.6a Platform : MS-DOS WINDOWS Issue type : kbprb
Last Reviewed: April 26, 1999