Import Data Wizard Fails Silently To Import Excel Files With Sql Developer 1.5.1.5440 (Doc ID 743067.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle SQL Developer - Version: 1.5.1 to 1.5.3
Information in this document applies to any platform.

Symptoms

Attempting to import data from an excel file into a table using sql developer fails silently: Once reached the NEXT or FINISH buttons, clicking will have no effect.

Steps to reproduce:
Right-click on a target Table -> Import Data -> select the Excel file and open it ->  The data are visible but the Worksheet combo box can be empty (or not) or even absent , but in all cases, nothing happens after clicking on NEXT or FINISH

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms