I have a very large Microsoft Excel file that will not
Import even after setting a 5GB heap size for Java as follows.
Needs["JLink`"]; ReinstallJava[JVMArguments -> "-Xmx5g"];
The file can be found here as the "UIC INJECTION VOLUMES 2014" download and is only 64MB.
I am now attempting to open it with
Needs["DatabaseLink`"]; conn = OpenSQLConnection[JDBC["Microsoft Excel", filename]]
but am getting a JDBC error.
Any ideas to either import with
OpenSQLConnection or some other method?
Is this a bug that it will not import a 64MB file with a 5GB java heap size?
Confirmed bug CASE:3760897
Version 11 is using Java 1.8 but some of the JDBC drivers are using jdbc:odbc bridge which is no longer supported in Java 1.8. WRI is working on updating all JDBC drivers to be Java 1.8 compatible.
Download a portable version of Java 1.7 and using JLink's
InstallJava[CommandLine-><path>]to install. This would let all the out of date JDBC drivers work.
Download a pure JDBC driver for Microsoft Excel, install, and use.
Import the Excel file into Microsoft Access and use MS Access JDBC driver.
Save file as CSV and
Automate Excel through .NETLink (@AlbertRetey from comments)
Buy WRI Mathematica Link for Excel.