topic Re: ODBC Upload from Excel failed in QlikView

ODBC Upload from Excel failed

sonu8072 — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: ODBC Upload from Excel failed

alis2063 — Sat, 23 Dec 2017 19:48:45 GMT

Please refer the following thread,

Loading Excel Data into QlikView

Re: ODBC Upload from Excel failed

sonu8072 — Sat, 23 Dec 2017 21:00:22 GMT

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

Re: ODBC Upload from Excel failed

Anil_Babu_Samineni — Mon, 25 Dec 2017 07:21:11 GMT

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?

Re: ODBC Upload from Excel failed

pipuindia99 — Tue, 26 Dec 2017 16:24:22 GMT

Hi,

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

Re: ODBC Upload from Excel failed

mgavidia — Tue, 26 Dec 2017 20:22:11 GMT

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.

Re: ODBC Upload from Excel failed

sonu8072 — Tue, 09 Jan 2018 17:12:05 GMT

Thanks Miguel!