Loading data from multiple xls files to oracle table

Question

I have Multiple XLS files . I have stored these file names in a table as below

TABLE NAME SEQUENCE

FILE1.XLS 1 FILE2.XLS 2 FILE3.XLS 3

Each file has 3 fields

FIELD1 FIELD2 FILED3

Now I have to load to data in table which has four column

FIELD1 FIELD2 FIELD3 FIELD4 , where FILED4 should be field by SEQUNCE of file name.

Please suggest the way to load the data from the files

Answer 1

If you convert the Excel spreadsheets to CSV you can load them using External tables.

Answer 2

You can use UTL_FILE package or external table. With external table you cannot use a wildcard while mentioning the file name, so you would need to run a loop and call it from a shell script.