topic Error while loading excel file? in QlikView

Error while loading excel file?

Thu, 19 Jun 2014 10:05:58 GMT

Hi,

Can anyone help me with below error please?

thanks.

Re: Error while loading excel file?

its_anandrjs — Thu, 19 Jun 2014 10:08:11 GMT

What is the error message.

Re: Error while loading excel file?

Thu, 19 Jun 2014 10:08:54 GMT

Please see attached in my original post and help me please.

Re: Error while loading excel file?

alexandros17 — Thu, 19 Jun 2014 10:09:40 GMT

Why do you load xlsx file with odbc???

You may load directly ....

Re: Error while loading excel file?

amit_saini — Thu, 19 Jun 2014 10:11:48 GMT

Hi Ameila,

Make sure you have required driver installed and provide that driver and server name in connection string too like:

DRIVER={XXXX Driver V XXXX};Provider=msdaora;DSN=U500.WORLD;Uid=xyz;Pwd=123;SERVER=localhost;"

Thanks,

Re: Error while loading excel file?

amit_saini — Thu, 19 Jun 2014 10:13:10 GMT

Also I'm not sure why you are using ODBC connection for uploading excel sheet.????

Thanks,

Re: Error while loading excel file?

its_anandrjs — Thu, 19 Jun 2014 10:17:39 GMT

May be it is ODBC excel driver problem check this on the system where the driver available or try to recreate the ODBC connection for excel

//Connection

ODBC CONNECT TO [Excel Files;DBQ=D:\Qlikview\Sources\Creditor Meeting Split.xlsx];

Re: Error while loading excel file?

Thu, 19 Jun 2014 10:19:30 GMT

Hi Amelia,

You do not have to use an ODBC connection to load data from excel.

All you do is you click on the "Tables Files" button and then simply select your excel spreadsheet. You then select the sheet inside the excel spreadsheet that you want to use and you are ready to go.

Regards,
Marius

Re: Error while loading excel file?

Thu, 19 Jun 2014 10:21:26 GMT

Thanks. I agree. But I have a requirement to load through ODBC as I have 50 sheets data in workbook. I can bot make all 50 sheets in table files so I would prefer this. Would it possible to set tis please help.

Re: Error while loading excel file?

Thu, 19 Jun 2014 10:25:42 GMT

Do all of the sheets have the same data structure?

And what naming convention does the sheets have?

Maybe you can loop through one load and fetch data from all 50 sheets by using a variable, if the data structure is the same.

Re: Error while loading excel file?

amit_saini — Thu, 19 Jun 2014 10:26:13 GMT

Amelia ,

You can load all those excel sheet in one shot. Please follow my comment here below:

. If an excel file contains multiple sheets wit... | Qlik Community

Thanks,

Re: Error while loading excel file?

Thu, 19 Jun 2014 10:27:18 GMT

I have used the below one

tables:
SQLTables;

DISCONNECT;

Tables1:
load
*,
replace(TABLE_NAME,chr(39),'') as NEW
resident tables;

DROP Table tables;

let var=NoOfRows('Tables1');

FOR i = 0 to $(var)-1
let sheetName=subfield(peek('NEW', i,'Tables1'),'$',1);

[$(sheetName)]:

Fact:
LOAD Id

FROM
[..\Source_Conversion\Creditor Meeting Split.xlsx]
(ooxml, embedded labels, table is [$(sheetName)]);

NEXT i

DROP Table Tables1;

STORE Fact into C:\Qlikview\table.qvd (qvd);

Re: Error while loading excel file?

Anonymous — Thu, 19 Jun 2014 10:29:25 GMT

Read this.I had a same situation

Re: Excel data import from Multiple tabs dynamically

Re: Error while loading excel file?

ThornOfCrowns — Thu, 19 Jun 2014 10:33:35 GMT

And does this work?

Re: Error while loading excel file?

Thu, 19 Jun 2014 10:54:59 GMT

I used the same. But the problem is it is showing ODBC error. please help how to set this.

Re: Error while loading excel file?

Anonymous — Thu, 19 Jun 2014 11:02:28 GMT

send me the code you have used and the error details

Re: Error while loading excel file?

jerrysvensson — Thu, 19 Jun 2014 12:05:47 GMT

Yes it works if you have installed Excel on your publisher machine.