Search code examples
oracle-databaseimportoracle-sqldeveloperimport-from-excel

Import data from Excel with SQL Developer 4.2


How can I import data from Excel files using SQL Developer 4.2?

I have been following these instructions (from SQL Developer 4.1 New Features - Import Data Wizard), which used to work in SQL Developer 4.1.x but, apparently, SQL Developer 4.2 can only import from text files (delimited or CSV):

Data Import Wizard


Solution

  • You have to pick your file first.

    Where it says 'Data Import File' click 'browse.' Then pick your XLS or XLSX file.