topic Excel loading using ODBC Issue in QlikView

Excel loading using ODBC Issue

tresB — Fri, 24 Sep 2010 08:09:14 GMT

Hi All,

I have created an ODBC connection to fetch the multi sheet excel file. The file originally contains 131 sheets. when i am loading it is showing 262(just double) tables (every sheet is duplicated by a name as originalname with an underscore follwed). I think its a driver problem. Any idea ?

your inputs are most welcome.

Thanks & regards,

tresesco

Excel loading using ODBC Issue

Miguel_Angel_Baeyens — Fri, 24 Sep 2010 08:13:19 GMT

Hello,

Is it possible you don't want to concatenate tables but you are not setting a table name so it takes the previous table name +1? Do the tables have to concatenate? Are you loading using any loop form?

Regards

Excel loading using ODBC Issue

tresB — Fri, 24 Sep 2010 08:26:21 GMT

Hi Baeyens, thanks for your reply.

Yes need to do that. But before i go to load the sheets using the following code gives me the erroneous out put:

ODBC CONNECT TO [fxls;DBQ=D:\....

XLtable:

SQLtables;

DISCONNECT;

let tt=NoOfRows('XLtable');

trace $(tt); // this one is showing me the count double(no of rows)

...tresesco

Excel loading using ODBC Issue

Miguel_Angel_Baeyens — Fri, 24 Sep 2010 08:38:44 GMT

Hi,

What ODBC driver are you using? I'm reading here office 2007 files with Office 2003 ODBC and returns the right number of tables. (A few sheets, though)