#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    2
    Rep Power
    0

    Text/Excel file to Oracle db


    I have my data in either a text or Excel file delimited by a comma. I would like to upload these data into the oracle database. Could someone tell me how to do this.
    Thanks in advance
    ssrg
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    538
    Excel won't be an easy task (from oracle's point of view), export to csv or other textual file and import with SQLLoader or External tables (9i and above).
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Location
    Manchester, UK
    Posts
    23
    Rep Power
    0
    To insert Excel data into Oracle is easy using the SQL*XL addin for Excel. You may want to check it out at www.oraxcel.com.

    SQL*XL expects as input:
    1. the table name
    2. the column names
    3. the address of the range that contains the data

    SQL*XL's dialogs help you to complete the input list. You can use the mouse to select the cell ranges etc.

    Have a look at SQL*XL at www.oraxcel.com

    Any question, just ask!

    Gerrit-Jan Linker
    www.oraxcel.com (SQL*XL)

IMN logo majestic logo threadwatch logo seochat tools logo