Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Loading Data in Table

 
adeeb alexander
Ranch Hand
Posts: 268
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic