aspose file tools*
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
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Loading Data in Table