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!

oracle external table - read .xls file directly

user5716448Jun 20 2019 — edited Jun 26 2019

Hi,

11.2.0.3 and getting supplied a .xls file (excel 97 spreadshheet from external provider)

Have used external tables to read .csv files.

Is there a way we can read the .xls file directly as am external table tried but message below as these files will be supplied automatically and cannot manually save as .csv

KUP-04026: field too long for datatype

KUP-04101: record 1 rejected in file

Thanks

This post has been answered by Paulzip on Jun 20 2019

Jump to Answer

Added on Jun 20 2019

13 comments

4,746 views