Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    Chennai, India
    Posts
    1

    Post Unanswered: Excel ==>> Oracle

    hi,

    I have data in an excel sheet that needs to be moved to Oracle DB. There are around 1000 records in total and this exercise is an one time exercise.

    I guess atleast a few of you would have done this already. Please suggest the best way to achieve this.

    TIA

  2. #2
    Join Date
    Feb 2004
    Location
    Jordan
    Posts
    137

    Re: Excel ==>> Oracle

    hi

    this is a text file with procedure that i use,
    use the same with ur tables



    Originally posted by dhannu74
    hi,

    I have data in an excel sheet that needs to be moved to Oracle DB. There are around 1000 records in total and this exercise is an one time exercise.

    I guess atleast a few of you would have done this already. Please suggest the best way to achieve this.

    TIA
    Attached Files Attached Files

  3. #3
    Join Date
    Jan 2004
    Location
    Singapore
    Posts
    89

    Re: Excel ==>> Oracle

    Originally posted by dhannu74
    hi,

    I have data in an excel sheet that needs to be moved to Oracle DB. There are around 1000 records in total and this exercise is an one time exercise.

    I guess atleast a few of you would have done this already. Please suggest the best way to achieve this.

    TIA
    Convert ur excel file to .csv (ie comma seperated) and use sqlloader.
    Thanks and Regards,

    Praveen Pulikunnu

Posting Permissions

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