Home » Developer & Programmer » Forms » Exporting Data from EXCEL file into ORACLE TABLE
Exporting Data from EXCEL file into ORACLE TABLE [message #80700] Mon, 04 November 2002 07:31 Go to next message
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 Go to previous message
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
Previous Topic: ORA-01001 invalid cursor error
Next Topic: Help me to write a Query
Goto Forum:
  


Current Time: Thu Mar 28 13:39:10 CDT 2024