Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2013
    Location
    Mauritius
    Posts
    11
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Import data from Excel to Oracle table

    Hi guys,

    I want to import data from an excel sheet to a table (newly created) in Oracle.
    Can anyone help me?

    Thank you,
    Tia

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    People who frequent this forum are likely to suggest that you link to the Oracle table you want to import data into using ODBC, and then attach the Excel worksheet as a table, all in an Access database, and then use an append query to populate the Oracle table. All of which would work, but seems a rather convoluted way to approach it. We don't have many people with significant Oracle experience, but I would expect there are tools available in Oracle that will import data from Excel or delimited text format, much like the tools that are available in SQL Server, which many of us do have experience.
    Wendell

  3. #3
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Midwest, USA
    Posts
    108
    Thanks
    5
    Thanked 5 Times in 4 Posts
    Oracle has built in functions to convert a comma separated list into a PL/SQL table. Search your help for DBMS_Utility.COMMA_TO_TABLE. It has been years since I worked with Oracle, but I don't believe this is too hard to do.
    Export your Excel table as a comma separated file and import it using the above mentioned utility.

Posting Permissions

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