Import data

I believe you need to use  SQL*Loader  utility to load data from Excel to Oracle. Save the excel file as a CSV file then this will be used as the input file defined in the SQL*Loader controlfile. If you are running 9i you can use External table feature.

Hope this helps

You can't use sqlplus as an import tool.You need to use sql loader.

Save your Excel file as csv file and use sql loader.

For more on sql loader go to :

http://www.orafaq.com/faqloadr.htm

There's also a tool at : http://www.oraxcel.com/

and the result:

SQL> select * from emp1;

    DEPTNO ENAME                       SAL
---------- -------------------- ----------
         1 Robert                     1000
         2 Kenvin Hunt              1200
         3 Michel                     1500

Hi baonguyen1,
Like I said, I'm not very familiar with this database environment and neet to know little bit more, for step 3 and 4, where should I excute the command?
thanks...

3. The controlfile should be located on the server. IT's just a text file
4. This command should be issued on the server.

You copy over the csv file to the server and place it at the location you specified in the control file:

infile '/db02/test/emp1.csv'

Now it could be grade at A ;-)))

Cheers,

how to import data into  a table ??? (ORACLE)
 I have 2 users x and y. and a table abc in both x and y. i want to copy data of a@x  into data of a@y.if i am using 'imp'/ 'exp' every time i need to drop a@y and then import ..i dont want this method.and using s/w like oraExcel taking lot of time to process...does any of u have any soln

sorry I didn't got where to post question..so I posted here..