Results 1 to 3 of 3

Thread: Export data from excel spreadsheet to an Oracle Table

  1. #1
    Join Date
    Apr 2009
    Posts
    22

    Export data from excel spreadsheet to an Oracle Table

    How could I fetch data in from an Excel spread sheet into an oracle table? Any examples appreciated...!

  2. #2
    Join Date
    May 2008
    Posts
    3,316

    Re: Export data from excel spreadsheet to an Oracle Table

    Open the worksheet you need to export to oracle & save it in csv format and In oracle write a control file to load data into Oracle using sqlloader.

    Hope This Helps You...!

  3. #3
    Join Date
    May 2008
    Posts
    4,345

    Re: Export data from excel spreadsheet to an Oracle Table

    Try this code & if any error occur post Back here...!

    export ORACLE_HOME=/u01/app/oracle/product/9.2.0
    export PATH=$PATH:$ORACLE_HOME/bin
    sqlldr userid=mag/mag control=member.ctl bad=member.bad
    if test -s member.bad
    then
    mailx -s 'errors in sqlLoad.following records are rejected' client@client.com < member.bad
    fi
    touch member.bad
    rm member.bad
    This is control file used by sqlloader

    load data
    infile 'member.dat'
    replace into table member
    fields terminated by ',' trailing nullcols
    (name, address)

Similar Threads

  1. To export an access table definition into Excel
    By bhola in forum Windows Software
    Replies: 3
    Last Post: 03-09-2009, 06:24 PM
  2. Insertion of clean Excel data into oracle table using html
    By Valerian in forum Software Development
    Replies: 3
    Last Post: 13-06-2009, 10:04 PM
  3. Replies: 5
    Last Post: 26-02-2009, 08:14 PM
  4. How to Export a table from a PDF File into an Excel Sheet
    By Computer_Freak in forum Tips & Tweaks
    Replies: 1
    Last Post: 05-02-2009, 11:21 AM
  5. Importing HTML table in a Spreadsheet - Excel 2007
    By Aarif in forum Tips & Tweaks
    Replies: 1
    Last Post: 01-12-2008, 03:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,638,435,441.02566 seconds with 17 queries