DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: transporting excel

  1. #1
    Join Date
    Aug 2005
    Location
    Nigeria
    Posts
    14

    transporting excel

    hello there,

    I just installed 10g on my laptop n i want to transport an excel table to oracle database but i couldn't get through. can somebody help me out.


    Thank you.



    Wole.
    The purpose of life is a life of purpose.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool


    Save spreadsheet as csv -- use SQL*Loader utility to load into Oracle table.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Dec 2003
    Posts
    2

    Thumbs up

    Hello,

    The latest version of DreamCoder includes some good options to upload data, I imported 5 Excel workbooks with 200.000 records apro. and just took 6 minutes.

    Check this link : http://www.mentattech.com/themes/men...der/index.html

    Regards,

  4. #4
    Join Date
    Aug 2005
    Location
    Nigeria
    Posts
    14
    Thank you all for your help, but am still having problem in loading from file since sql*loader has its own format, like bad file, controlfile etc. Can you pls help me on how to go about transporting it into my datatbase.

    Thank you.
    The purpose of life is a life of purpose.

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