Microsoft released some date-related patches to Excel in late December. Check at http://officeupdate.microsoft.com/downloadCatalog/dldExcel.asp for a list. In particular, you may want to check out the "Microsoft Excel Programmatic Text Export Update" patch. There's one for Excel 2000, Excel 97, and Excel 95.


>Hello.
>
>I have a problem with date values when importing Excel files, where values above 1999/12/31 values are incorrectly imported.
>
>For example, with a source date of 00-01-01 in excel, I ended up with 1899-12-31 in the imported DBF file. For this example the following settings were in effect: CENTURY OFF (on yeilded similar results), DATE TO YMD and MARK TO "-". I have tried other ettings, with other invalid result. Also, I am using Visual Foxpro 6.0, with no Visual Studio Service Pack.
>
>Could VS Service Pack 3 solve this problem? If not, any help in finding a solution to this problem would be appreciated.
>
>Thank you... and happy new year :-).
>
>Yan Vaillancourt