Ole Kristian
Member
Hi!
I have experienced some problems when importing data from an excel file using the ODBC import tool:
The excel sheet I having problems with has about 45 000 rows and when I try to import this sheet I get the following eror message:
"ORA-01400 Cannot insert NULL into ("NETBAS90","PAKKEMALRELASJON", "PAK_RENNUMMER1")"
The field PAK_RENNUMMER1 has a "not null" constraint, so the error message is correct, but the excel data doesn't contain any empty cells so I shouldn't have got the error message at all! I successfully imported the same data by using the sql * loader tool, so it must be bug.
I'm using version 7.0.1.1066
I have experienced some problems when importing data from an excel file using the ODBC import tool:
The excel sheet I having problems with has about 45 000 rows and when I try to import this sheet I get the following eror message:
"ORA-01400 Cannot insert NULL into ("NETBAS90","PAKKEMALRELASJON", "PAK_RENNUMMER1")"
The field PAK_RENNUMMER1 has a "not null" constraint, so the error message is correct, but the excel data doesn't contain any empty cells so I shouldn't have got the error message at all! I successfully imported the same data by using the sql * loader tool, so it must be bug.
I'm using version 7.0.1.1066
