Excel file in Oracle Table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Excel file in Oracle Table

  1. #1
    Join Date
    May 2001
    Location
    London
    Posts
    149

    Excel file in Oracle Table

    Dear Guys,

    I want load data in the excel file into Oracle table.
    I know we cant load excel files directly into table but is there any way I can convert excel file into CSV format.

    Any suggestions are welcome.

    Thanks
    Paresh

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    File/Save As and then select the type to be csv!

  3. #3
    Join Date
    May 2001
    Location
    London
    Posts
    149
    I know by saving that file as .CSV format will covert the excel file into csv format. But is there any windows or unix utility which will convert the excel file into csv format? because i dont want to do it manually...

    any suggestions??

    Paresh

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Win :
    Code:
    Rename MY_FILE.xls MY_FILE.csv
    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  5. #5
    Join Date
    May 2001
    Location
    London
    Posts
    149
    Thanks for the reply...

    when i ran above command, it creates .csv file but it contains junk characters.

    Is there any other option?

  6. #6
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    If you don't find a conversion program, you could (as a last resort) make an Access db with macros that Import the Excel file and send the data to Oracle by ODBC, this kind of thing can be run from a batch. I'm sure only Bill Gates thinks that this is the ideal solution

  7. #7
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    why don't you google some "command line tool convert excel csv"?
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

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