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!

Read excel file (.xlsx) as external table

user5716448Apr 21 2020 — edited Apr 21 2020

Hi,

We are able to read a .csv file as ORACLE external table (version 11.2.0.3)

We can save .xlsx as .csv but this is manual step.

Is there a way of automating this in ORACE so external table can read .xlsx file directly or some oracle function/routine that could convert the .xlsx file directl to .csv in th external table definition.

Thanks

This post has been answered by BEDE on Apr 21 2020

Jump to Answer

Added on Apr 21 2020

8 comments

7,818 views