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