Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel file to dbf - date truncated
Message
 
À
28/06/2004 08:54:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00917870
Message ID:
00917957
Vues:
8
is the very first date entry on the excel column 19 chars long?
Slán
~M

>Hi,
>
>I had manually check both file, both seem to be the
>same, just that one of the keep truncated to 19 only
>
>>have you looked at the cell and column setting in the excel sheet?
>>Slán
>>~M
>>
>>>Hi,
>>>
>>>Thank, but my application initially set the century on,
>>>only this excel file had this problem.
>>>
>>>Any other suggestion or advise.
>>>
>>>>Maybe somehow the SET CENTURY is different in your 2 applications?
>>>>
>>>>Jaime
>>>>
>>>>>Hi,
>>>>>
>>>>>If my application using automation to open excel file
>>>>>and save them as dbf file, only one of the excel file had
>>>>>the date truncated from 1987 to 19 only.
>>>>>
>>>>>Other excel file that I work on, does not
>>>>>give this issue.
>>>>>
>>>>>Any way to solve this issue.
>>>>>
>>>>>Thank you
Go raibh maith agat

~M
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform