I checked again to make sure, and that is indeed the case.
The Excel file had improper date values (whoever made it just entered "00" for the year and did not check the century), so it seems everything is in order.
FYI, I am using Excel 97.
Thank you for your help :-).
Yan Vaillancourt
>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...
>
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