Results 1 to 10 of 10
  1. #1
    Join Date
    Sep 2006
    Posts
    8

    Unhappy Unanswered: How to Import Data in Oracle

    hi...
    i want to import the data in oracle from Excel spreadsheet.
    i know 1 way to import i.e. SQLLDR. but i dont know how to use it.
    can any1 tell me how to do this.

    Regards
    Manu Verma

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    There is more than one way to do that; if Excel spreadsheet contains only a few records, perhaps it is easier to manually type INSERT statements than learn new concepts.

    Another one is SQL*Loader. It is invoked at the operating system command prompt, requires a control file which tells Loader HOW to insert data.

    Third option is use of external tables. This is quite convenient, but your Oracle version must support it (I believe 9i onwards does).

    To be able to use ANY of those ways, Excel spreadsheet must be saved as a Comma Separated Values file (CSV). Genuine .XLS won't do any good.

    Get familiar with SQL*Loader and external tables on these Oracle Technology Network pages.

  3. #3
    Join Date
    Sep 2006
    Posts
    8
    hi dear..

    i have large no. of records in excel spreadsheet. i m using Oracle 9i release2 version. please tell me which is the best option and easiest way to import my
    excel sheet in to oracle database.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Read post #2 in this thread again.

    Or, would you like me to give you my e-mail address so that you could send me this Excel file. I'll load it into a table, make an export and mail it back to you. How about that?

  5. #5
    Join Date
    Sep 2006
    Posts
    8
    Thanks Bro... but i need to learn this bcz i have so many files. it updates on regularly so i need to import many times. culd u plz tell me step by step how to import it into oracle or we can chat on yahoo ( younker1983@yahoo.com ).

  6. #6
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Read post #2 in this thread again.

  7. #7
    Join Date
    Jul 2003
    Posts
    2,296
    try saving the excel spreadsheet in comma-delimited format (.csv)
    once in that format create a sqlloader controlfile t0 accomodate the delimiter.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  8. #8
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    And what am I saying all the time?!?

  9. #9
    Join Date
    Jul 2003
    Posts
    2,296
    Quote Originally Posted by Littlefoot
    And what am I saying all the time?!?
    yeah, but it seemed he wasn't taking you seriously or was ignoring you.
    :P
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  10. #10
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Oh well, if I were him, I wouldn't take myself seriously either

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •