topic Re: The cell format is not Date in in Talend Studio

The cell format is not Date in

Anonymous — Tue, 17 Nov 2015 22:02:59 GMT

Hi,
I'm using the excel source data to load the data into the relational table and I'm getting below error.
Can anyone please help me?
The cell format is not Date in ( Row. 2 and ColumnNum. 6 )

Thanks,

Re: The cell format is not Date in

Anonymous — Wed, 18 Nov 2015 01:53:18 GMT

Are you trying to insert non-date data from the excel into a date data in the relational table? Maybe you have to format it into a date first.

Re: The cell format is not Date in

Anonymous — Fri, 20 Nov 2015 14:39:17 GMT

Hi,
I think you have 2 solutions :
- convert your excel column file into date format and import your file
- import your file and conevrt the string date into date (use TalendDate.parseDate("yyyy-MM-dd", row1.yourData))

Re: The cell format is not Date in

Anonymous — Fri, 11 Dec 2015 09:15:35 GMT

Hi,
Can we consider this topic as resolved ? If yes, can you prefix this title topic with ?
Thanks,
Arnaud