Importing Data from excel to Oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Importing Data from excel to Oracle

  1. #1
    Join Date
    Mar 2007
    Posts
    1

    Question Importing Data from excel to Oracle

    How to import data from excel table to Oracle/SQL table?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    csv, external tables or sqlloader

  3. #3
    Join Date
    Nov 2001
    Posts
    335
    Microsoft Access, link to external data sources probably can be used too
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  4. #4
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Sounds like you have a MS solution and an Oracle solution...

    There used to be a really cool excel add-on called Second Wind that would tie ODBC databases to Excel really nicely...

    If it were me, I would create insert statements in the excel spreadsheet, then copy/paste them to sqlplus. In the column next to the data, 'insert into tablename '|| ... &A1... bla bla

    Ken
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  5. #5
    Join Date
    Jun 2005
    Location
    Florida
    Posts
    41
    If this is one time task, you may want to go to www.benthicsoftware.com and download a tool called golden. It has a nice rxp-imp utility and you can upload/download data from csv/text files easily.
    Milind
    -----------------------------
    www.milinds.com
    My Private World on the Web !

Posting Permissions

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


Click Here to Expand Forum to Full Width