1.5.1: Excel import - Problem with NULL values in date fileds

10368

Hi,

I'm trying to import Excel Data via CSV with the import into table feature of SQLDeveloper.

Everything works fine, but if I select some of my date colums I get an error telling me that I have null or invalid values in a date column:

Verifying if the Date columns have date formats
FAILED
Date columns SOA_CONTROLLING_NO, SOA_DATE_OF_CONTROLLING, PAYOUT_ME_2_SUM, PAYOUT_ME_1_SUM, PAYOUT_PLUS_SUM, PAYOUT_6_SUM, PAYOUT_5_SUM, PAYOUT_4_SUM, PAYOUT_3_SUM, PAYOUT_2_SUM, PAYOUT_1_SUM, CONTRACT_APPENDIX_SUM, CONTRACT_BASE_SUM, ME_CONVENANT_SUM, REF_SUM_NO_REPAY, SEL_CONVENANT_SUM, ME_REQ_SUM, REF_REQ_SUM_NO_REPAY, SEL_REQ_SUM, have invalid or null date formats

I tried:
+20012121313,demo1,,+
+20012121313,demo1,NULL,+
+20012121313,demo1,to_date(NULL),+

but none of them worked...

How may I import those columns, where some of the rows contain NULL values?

Same story using 1.5... ;-(

Thank you!

Best regards,
Johann