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