Six Stars

date format issue

Here is another issue I am facing today. I am trying to load data from Excel to my OracleDB. the excel contains lot of 'Date' fields. As I run my job, I am getting the error that 'the cell format is not Date in Row and column..'. I have mapped columns accordingly as well

Attaching screenshots. Kindly suggest.

dateissue.jpgdateissue2.jpgdateissue3.jpg

 

  • Data Integration
1 ACCEPTED SOLUTION

Accepted Solutions
Employee

Re: date format issue

I think this has to do with the Excel cell data format.  Is it set as Date in Excel format?

1 REPLY
Employee

Re: date format issue

I think this has to do with the Excel cell data format.  Is it set as Date in Excel format?