In my work as a consultant I often have the task of getting data from MS Excel spreadsheets into tables in the database.
If this is a one-time load, the process is simple – use either SQL Developer or, easier yet, use the Data Load Workshop in APEX: SQL Workshop –> Utilities –> Data Workshop.
If the requirement is for a repeated load or many files, I need to set up some automated process for reading in the data. I do not want to ask my users to open the XLSX files, save the data to CSV, then upload the CSV files. That makes for unhappy users, at best.
I am sure there are several options for load XSLX files into Oracle data tables. I am going to focus on a two I have used (and continue to use) successfully across several clients, across many projects. And another option that…
View original post 1,036 more words