A reader, April 27, 2017 - 11:49 am UTC
Is there any way to load xls and xlsx file into oracle table.
i can't change the file to csv from xls or xlsx.
April 27, 2017 - 11:42 pm UTC
A more recent tool
Stew Ashton, April 28, 2017 - 9:17 am UTC
Marc Bleron wrote a PL/SQL routine to read .xlsx files. I have used it quite a bit since then.
https://odieweblog.wordpress.com/2016/06/21/reading-an-excel-file-xlsx-as-an-external-table/ The interface lets us work with files or LOBs! I think the external table interface really missed the boat here: having a LOB interface to an external table would allow us to upload the file using SQL*Net and use database security to control access, without having to worry about file system security issues. As far as I know, people who need to access LOBs have to work around this with DBFS.
Best regards, Stew