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