SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert an .xls file to .csv file using procedure or function

SakthiOct 13 2010 — edited Oct 13 2010

Hi All,

My requirement is as follows.

1. In my database server(linux), my excel file will be loaded in a particular directory.
2. I need to load this excel file's data into an external table.
3. Can i load the data from an excel file to table directly? Or do i have to change the format into .csv, if so how to conver the .xls file to .csv file via backend.

Please help me.

Regards,
Sakthi.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 10 2010

Added on Oct 13 2010

1 comment

330 views