When trying to import large XLS or XLSX files, Mathematica may give the following error message:

 Import::fmterr: Cannot import data as XLS format. >>

J/Link is likely to have run out of memory. To resolve the issue in most circumstances:

1. Increase the Java heap space.
2. Re-run the Import command.

Please contact Wolfram Technical Support otherwise.