Home » SQL & PL/SQL » SQL & PL/SQL » import data in excel sheet to oracle
|
|
| Re: import data in excel sheet to oracle [message #19290 is a reply to message #19289] |
Fri, 08 March 2002 23:54  |
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
|
|
|
|
Goto Forum:
Current Time: Tue Apr 23 08:01:16 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
