Forum Stats

  • 3,837,505 Users
  • 2,262,265 Discussions
  • 7,900,308 Comments

Discussions

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

10368
10368 Member Posts: 173
edited Sep 18, 2008 3:56AM in SQL Developer
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
Tagged:
This discussion has been closed.