How to load multiple excel binary files (.xlsb) into qlikview

[#1]

Hi,

I am stuck with loading multiple .xlsb files in qlikview. I am trying the ODBC connection. I was able to upload the 3 heavy files (.xlsb files, approx ~ 750000 rows each which took good 7-8 mins for each files) in first attempt, now i am not able to load any data from the file.

Not even from the earlier loaded script which worked at first attempt!

Though, the connection string says its connected, am getting the following error:

Also a strange behavior from Qlikview , everytime i click the Connect databse button it popoluates the old connection string on the script. How can i make qlikview forget the old connection and create new ODBC connection?

Quick help 'll be highly appreciated.

Thanks,

Ashar

[#2]

Hi Ashar,

Did you find a solution to this issue? I've got a similar problem.

Thanks,

Craig

[#3]

I think I may have just found the answer (to my problem at least).

Looks like there needs to be double sets of quotes round the sheet name if it has spaces in it - for example:

SELECT *
FROM `$(file)`.`'User Summary$'`;

Hope this helps

Craig