General information
Title:
Date problems when importing excel files.
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only