• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Loading Data in Table

 
Ranch Hand
Posts: 268
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic