CODEWITHSUNDEEP
sqloracle-databaseplsqloracle-sqldeveloper
HARRJA
HARRJA

Reputation: 71

Issue Importing .xlsx into Oracle SQL Developer

I am trying to export a .xlsx file in to oracle via the import wizard. However, when I select the .xlsx file nothing happens, usually when I import .csv I then specify format etc, but I am just brought back to the home screen. The file is quite small so I don't see why this wouln't work. Does anyone have any advice? enter image description here

Upvotes: 2

Views: 661

Answers (1)

d r
d r

Reputation: 7766

The fastest way is to convert your excel data into csv and import it as usual. Depending on the size of file, version of sql developer, operating system there seems to be some problems with memory (especialy on 64-bit systems with 64-bit jdk) though the file looks small.
Some report says they are succeded to import xls file after increasing the SQL Developer virtual memory limit by adding a line like AddVMOption -Xmx1280M or larger into SQLDeveloper.conf file.
Converting xls to csv is easy, fast an less stressful than messing with config file.

Upvotes: 2

Related Questions