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