| Exporting Data from EXCEL file into ORACLE TABLE [message #80700] |
Mon, 04 November 2002 07:31  |
Qavi
Messages: 24
Registered: August 2002
|
Junior Member |
|
|
Hello Gurus !,
I have an urgent task to export EXCEL DATA INTO ORACLE TABLE .. i dont have any idea at all can u please tell me the way how to do the task .. its an urgent !! Thx in Advance
Rgds
Qavi
|
|
|
|
| Re: Exporting Data from EXCEL file into ORACLE TABLE [message #80702 is a reply to message #80700] |
Mon, 04 November 2002 11:10  |
Amit Kumar
Messages: 23
Registered: July 1999
|
Junior Member |
|
|
I have used a couple of ways to upload data from excel sheet :
1) Brute force : If the data is not much, u can use the 'concatenate' function in excel to create an insert statement. make it for any one row and propagate it to ur entire exxcel sheet. Test a couple of rows , if it works fine .. just copy and paste all the update statements.
2) Use 'concatenate' function to make "," separeated file and use sql loader.
Amit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
