ODBC Upload from Excel failed

[sonu8072]

Hi Folks!

I have an excel file with multiple sheets, which I want to load in Qlikview. I suppose the best way is to use the ODBC load (I am very new to Qlikview), which is not working for me; error screen shot -

Thanks in advance!

[alis2063]

Please  refer the following thread,

Loading Excel Data into QlikView

[sonu8072]

Thanks for the quick response Ali! My question still remains unanswered though, I have 1 excel file with many sheets in it...........

[Anil_Babu_Samineni]

This error comes out when we are checked all at a time only. So, You should do separate sheets only.. I would ask you to explain little more?

[pipuindia99]

Hi,

You have to upload the excel sheet having said with only one sheet tab at a time. otherwise you will get this error.

[mgavidia]

Aditya,

If the sheets in your Excel file have the same columns names, you can load it to QlikView as shown below.

Here, I am loading data from a single Excel file (with multiple sheets) into a file named RentalActivity2015.

The loading statement is the same the only thing changing is the sheet name that needs to be loaded. (Jan, Feb, etc, etc) . Since all sheets have the same columns names, QlikView will automatically concatenate the data.

[sonu8072]

Thanks Miguel!