Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    18

    Unanswered: Import Excel spreadsheet into oracle 9i

    Hia,

    As subject reads ... I want to import an excel sheet into oracle 9i. I am aware that I need to save the spreadsheet as .CSV but reading around I have seen sql*loader being used to do the import. Am I right in thinking 9i doesnt support this and uses external tables instead ? If this is correct then do I need privilages to create a directory on the oracle server when using external tables?

    Thanks in advance

    Greg

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    No, you are wrong - SQL*Loader is supported in 9i (and in 10g as well). Follow this link to read all about this Oracle utility.

    P.S. Search for "Managing External Tables" chapter on this page; you'll find a nice example of Creating an External Table and Loading Data there.
    Last edited by Littlefoot; 11-17-05 at 08:05.

Posting Permissions

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