biff

[denis115]

Hello everyone!

Help me please!

What should I do to send my excel file into qlikview?

When I try to do this it shows error   'cannot read biff files'

Thank you!

[denis115]

I'm sorry but this file is confidential, you can ask me questions if you want

I'll explain all from beggining:

my source code is 

load
[год],
[месяц],
[код]

from

(biff, embedded labels, table is база);

after reloading it shows error 'cannot read biff files'

[vardhancse]

Hi,

To load .xldb format files we need to install odbc drivers.

How to get data from xlsb to QlikView

[prma7799]

Please check this

ScriptError: Cannot read BIFF file - Any ideas?

[Peter_Cammaert · Accepted solution]

In QlikView, there is no Table File filter for XLSB files.

XLSB isn't even part of the OOXML format specification but a Microsoft-proprietary binary file format (BIFF12). Just like BIFF but different. More modern. Therefor, the BIFF table file filter in QlikView cannot be used to read this type of files either. That one can only read old (pre-Office 2007-style) XLS binary files.

An OOXML-format file is actually a simple .ZIP archive that contains various directories with a large amount of XML files (i.e. text). The OOXML file format filter in QlikView is able to read this kind of file, but not the binary XLSB format.

As has been suggested many times, you'll need to define an ODBC/OLE DB driver chain, because Microsofts own drivers can read XLSB files.

[woshua5550]

sorry , I'm wrong . actually we can load xlsb by ODBC , script like this

ODBC CONNECT32 TO [Excel Files;DBQ=C:\New Microsoft Excel Worksheet.xlsb];

SQL SELECT *
FROM `C:\New Microsoft Excel Worksheet.xlsb`.`Sheet1$`;

[denis115]

thank you!