Hi! First, Happy New Year for everyone.
Now, the question.
I was trying to load Excel data into Oracle through SQL Developer as I always did, when it was at version 3 and has always worked. But after I started to version 4, the following error occurs. When I select the file and it is loaded, the file preview some data fields has added letters and when I end the part load and insert the data, the data is entered as is in the preview and not as it is in the file. Anyone have any ideas?
Below is some prints. The fields that Sql Developer changes are in red.
The excel file is this.
The preview is this.
When I click finish that error occurs.
And Sql Developer insert it in the table.
When I insert the original excel line manually to the database via sqlplus, no error occurs and the data is perfect.
I hope the explanation has become clear.
Thank you!