i have an excel file i'm converting to an oracle temp table. i have a file of 900 last names i need in a table ... 1 field called "last_name" ... i figured this'd be simple. create table temp_last_name as (last_name varchar2(80) null); commit; so then i go to do the insert .... insert into temp_kim_names values ('Aabak', 'Adams'... 'Zephyr'); commit; ...and I get an "ORA-00913: Too Many Values" error. Now I don't get why this is when there's only one column ... that error is for when you're putting values into several columns. How can i populate this table?

One observation, the create table command only has one field defined, but your insert statment has data for two fields??

Sorry, just to be clear the insert statment: insert into temp_kim_names values ('Aabak', 'Adams') will put the value 'Aabak' into one column, and 'Adams' into another column into a single row. If Aabak and Adams are the values for one column and 2 rows, then you'll need two insert statements.

what i ended up doing was putting it in columns in excel, i created one column that says insert into temp_kim names values ( then the next column had all the values then the next column just had ");" in it (minus the quotes, of course)... so basically i used excel to create 900 insert statements for me then copied them over to dbartisan (my sql editor, similar to sql plus)