You are dealing with ambiguous dates in Excel. The dates should be in Excel as 2000-01-01, not 00-01-01.
Regardless, there is nothing preventing you from catching this in your import routine, unless of course, you are relying on Append From x Type XLS....
If you are, you will need to use Automation Techniques instead, so you can fix the values...
Changing how the dates are displaying in Excel may help as well. Just curious, what version of Excel are you using. In Excel 2000, if I enter 01/01/00, it automatically formats it as 01/01/2000.
If the values in Excel are entered as strings, as opposed to dates, then you are definitely going to have to rely on automation techniques to fix the data. In your Excel Template, I would then recommend that date types are used, and the 4 digit year to be displayed...
>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement