Toad World® Forums

TRYING TO IMPORT DATA FROM EXCEL SPREADSHEET INTO A NEW TABLE..

I KEEP GETTING THIS ERROR:

DO YOU WANT TO CANCEL IMPORT? CLICK TO IGNORE THE CURRENT ERRORS AND ANY ADDITIONAL ERRORS CONTINUE EXPORTING.

Failed inserting from row #0 to #361 without detailed row number info : ORA-01461: can bind a LONG value only for insert into a LONG column

Do you want to cancel the import? Click no to ignore the current error(s) and any additional errors and continue importing. Toad will not prompt you again if another error occurs.

We do not currently support inserting data into LONG, CLOB, or BLOB columns. You can insert LONG values into a new table with column defined as VARCHAR. Or you can import the rows and exclude this column.

Debbie

hI dEBBIE- THE FUNNY THING IS THAT IT’S ALIST OF NUMBERS THAT i AM TRYING TO IMPORT, NOTHING ELSE.

But what is the data type of the target table you are importing to? Can you post a screenshot of the DDL or column datatypes?

Debbie