Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Reply
deepakk
Partner - Specialist III
Partner - Specialist III

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