Convert excel files into Oracle Tables
Oracle Database Tips by Donald BurlesonMay 8, 2013
Question: What is the easiest way to convert
excel spreadsheet files into Oracle tables?
are several approaches for getting Excel data into Oracle:
Convert Excel file directly from
the spreadsheet - The best way to do this fast is
Define the excel spreadsheet as
an Oracle external table - If you convert the
spreadsheet from an xls file to a csv (comma-delimited)
format, you can define the spreadsheet as an
Load the Excel Spreadsheet from
This thread shows some code for loading data from a
spreadsheet directly into an Oracle table.