Problem in importing excel with date/ timestamp field using oracle sql-developer

I tried to upload file in excel file to the sqldeveloper and faced problem date is null or invalid format


below is the steps how to solve it

1. open sqldeveloper , Tools --> preferences --> databases --> NLS

properties

1. check Date format and Timestamp format
2. Open the Excel Sheet
3. make the format of the cells in Excel sheet General and write the dates in the same format in the sqldeveloper
4. write the date with the same format

you data will be easily imported


Solution (2)

1. write a sample data in the table 
2. export the data in excel format.
3. use exported file as a template and copy past the data into it  

Solution (3)

• http://www.thatjeffsmith.com/archive/2012/04/how-to-import-from-excel-to-oracle-with-sql-developer/

References :

• http://stackoverflow.com/questions/6066780/excel-date-field-import-problem-in-oracle-sql-developer