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 -
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.