1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Importing datas into oracle db

Discussion in 'Security, Backup and Recovery' started by Nithya, Dec 30, 2009.

  1. Nithya

    Nithya Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80
    How to import data from an excel sheet into oracle database using sql loader..can anyone tell me the step by step procedure for it..is there is any other way other than sqlldr?
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You will need to export the data in the spreadsheet into a text file (CSV is fine) then write your SQL*Loader control file to use the text file you created.

    Google is your friend:

    http://www.google.com/search?hl=en&...+data+into+oracle&aq=0&oq=load+excel+&aqi=g10
     
  3. Nithya

    Nithya Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80
    Thanks for ur kind information..