This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes Oracle/OAS and the fly likes Loading Data in Table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Loading Data in Table" Watch "Loading Data in Table" New topic
Author

Loading Data in Table

adeeb alexander
Ranch Hand

Joined: May 29, 2008
Posts: 268
Hi,
I have data in Excel and i want that to be loaded in oracle table, i am using oracle 10g XE, i have tried by sql loader but its quite lengthy process. I tried to load with the internal utility of oracle XE i.e to upload a file but i am facing great difficulties can any body help me please.
Thanks and
Regards.
Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
the only other methods I can think off is to export the xl file as a comma delimited text and then define a external table using that data or write a java pgm to parse it and load it.
Romano Londt
Greenhorn

Joined: May 05, 2004
Posts: 14
Originally posted by adeeb alexander:
Hi,
I have data in Excel and i want that to be loaded in oracle table, i am using oracle 10g XE, i have tried by sql loader but its quite lengthy process. I tried to load with the internal utility of oracle XE i.e to upload a file but i am facing great difficulties can any body help me please.
Thanks and
Regards.


I struggled to with some Excell-sheets...
I modified all the collumns of the new import table table to varchar2(30000) and modified them after the initial load.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Loading Data in Table