Home » SQL & PL/SQL » SQL & PL/SQL » import data in excel sheet to oracle
import data in excel sheet to oracle [message #19289] Fri, 08 March 2002 20:00 Go to next message
Biswaranjan
Messages: 3
Registered: March 2002
Junior Member
I want to import data in excel sheet to oracle databse.can any buddy help me out
Re: import data in excel sheet to oracle [message #19290 is a reply to message #19289] Fri, 08 March 2002 23:54 Go to previous message
Milind S Deobhankar
Messages: 33
Registered: January 2002
Member
You can try two things out of which one is very simple
:

First Method :

From the excess go to the Get External data in the file menu go to the link the table then connect to the oracle using the ODBC select the table it will open in excel like sheet.

Copy the excel sheet and paste in to the access your data get inserted if there is any bad data then bad file will be created.

Second Method:

1. use the concatenate command in excel.Consider the following example having 7 column in excel file ,on the 8 th column do the concatenation in the following way.
=CONCATENATE("insert into test values(","'",A1,"'",",","'",B1,"'",",","'",C1,"'",",","'",D1,"'",",","'",E1,"'",",","'",F1,"'",",","'",G1,"'",");",)

After typing the above command in 8 th column 1 st row drag the mouse till the n th row(say 100 if have 100 values).
2.copy the column,Paste in notepad & save as ".sql" file.
3.run the ".sql" file from SQL*PLUS.

Third Method:

Save the file in cvs fromat anf load the same from the SQL Loader
Previous Topic: Update Statement Error
Next Topic: Data dictionary into a temp table
Goto Forum:
  


Current Time: Wed Oct 20 17:51:46 CDT 2021