Transfering data from MS Excel sheet to Oracle DB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Transfering data from MS Excel sheet to Oracle DB

  1. #1
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245

    Transfering data from MS Excel sheet to Oracle DB

    Hi,
    One of my developer has large data in excel sheet. now he wants to put it in Oracle database. I think through ODBC we can do it but i am not sure how.
    I searched on google and found one utility which will do this for me but hard luck link http://www.oraxcel.com/projects/sqlxl/ is not opening . So does any body here knows hoe to do it.
    or can anybody point me to any link where i can get any info

    Rgds
    Parag

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    This metalink note should help http://support.oracle.co.uk/metalink...&p_id=241351.1

    or read up on Oracle Objects for OLE http://otn.oracle.com/pls/db92/db92....emark=docindex

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    Thanks man I think metalink will help.I will try it.

    Rgds
    Parag

  4. #4
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    I'm sure I'm telling you something you already know, but you do realise that saving the .xls as a .csv and loading it with SQL*Loader is an option?

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