Import xlsx with more than 64k rows - QV 9 last release

[#1]

Dear all,

I'm trying to import an excel spreadsheet (xlsx) with about 500k lines.

It does not work, but only shows up an error in allocation of memory.

Thank you for your help in advance.

I'm using Qlikview 9 in the last Release, Windows XP, 4GB Ram

[deepakk]

hi,

Can you attach  the file, we can check it our end.  Also try the following activites.

1) load one field at a time and check which field is causing the problem.

2) try to increases your virtual memory.

If you are able to load the data then store it in Qvd. (Loading from qvd will be much faster.)

Deepak