Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2007
    Posts
    5

    Unanswered: Import Data from Excel to Oracle

    Hello,

    I need to select Fields in Excel: F1/F2/F3 where F1=x and to import the data from these fields into Oracle Database.

    Could You advise me how to make it?
    The best way for me is to use SQL, but how to make the connection between Excel and Oracle?

    Thank You in advanced
    Last edited by henker; 03-27-07 at 08:38.

  2. #2
    Join Date
    Mar 2007
    Posts
    5

    Import Data from Excel to Oracle

    Hello,

    I need to select Fields in Excel: F1/F2/F3 where F1=x and to import the data from these fields into Oracle Database.

    Could You advise me how to make it?
    The best way for me is to use SQL, but how to make the connection between Excel and Oracle?

    Thank You in advanced

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    2 ways ... the first is sqlldr ... good tool for this... the 2nd is to use
    external tables. You define the directory where excel file is located, then create a table .... You can then query the spreadsheet just like
    an Oracle table ...

    create directory external_input_dir as 'C:\...\directory';

    Create table temp_your_table_name
    (
    col1 VARCHAR2(20),
    col2 VARCHAR2(5),
    col3 VARCHAR2(35),
    )
    ORGANIZATION EXTERNAL
    (TYPE ORACLE_LOADER
    DEFAULT DIRECTORY external_input_dir
    ACCESS PARAMETERS
    (FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
    (col1, col2, col3))
    LOCATION ('Excel_File_name.csv'))

    HTH
    Gregg

  4. #4
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Quote Originally Posted by gbrabham
    You define the directory where excel file is located
    That file has to be a text file (comma or tab separated) not an Excel file. SQL*Loader cannot deal with "native" Excel files.

  5. #5
    Join Date
    Mar 2007
    Posts
    5

    Thanks for supporting me

    Thanks Colleagues,
    it was very useful for me

    Vasil Nikolov

  6. #6
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Glad it worked out

Posting Permissions

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