'Import data from excel to oracle SQL
When I'm trying to import data from excel to Oracle SQL. I keep getting an error
Data is not compatible with column definition or is not available for a not nullable column. and there are yellow Triangle in column 1 COLUMN 1 is EmployeeID. i just added number like 1, 2 ,3 . Any advice?
Solution 1:[1]
Yes
Show us your data. Show us the table DDL. And show us the picture of SQL Developer showing the errors.
Here, the EMPLOYEE_ID column is defined as a number, and you have rows in the Excel file that will fail because their values can't be casted as numbers.
If you look down at HIRE_DATE, there's no date format applied so we can take your strings and insert them as dates into the Oracle field
Observe the type, size definitions for the data - then observe the data in the preview window, and see what's not simpatico.
You may have to change your table definition to match.
I talk about this in more detail with a complete scneario on my blog.
If you prefer YouTube, here's a 30 minute video overview.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | thatjeffsmith |