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

Thread: excel loaing

  1. #1
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Hi,

    Can I directly load MS Excel files to Oracle DB without converting it to txt or csv files?

    Thanks,

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    You cant load Excel files directly because they are binary files.
    You should export them to a comma delimited/text file and then use the sqlldr utility to load/append data to the table.

    regards,
    Rotem.

  3. #3
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Thank you rotem,

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    There is plug-in product for Excel (SQL*XL) available that can do this.
    URL: http://www.oraxcel.com

    Sanjay

  5. #5
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Thanks again San,

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