Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
sonu8072
New Contributor III

ODBC Upload from Excel failed

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 -

Error.PNG

Thanks in advance!

6 Replies
alis2063
Contributor II

Re: ODBC Upload from Excel failed

Please  refer the following thread,

Loading Excel Data into QlikView

sonu8072
New Contributor III

Re: ODBC Upload from Excel failed

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

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?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
pipuindia99
Contributor III

Re: ODBC Upload from Excel failed

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
Contributor

Re: ODBC Upload from Excel failed

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.

Image-1418.png

sonu8072
New Contributor III

Re: ODBC Upload from Excel failed

Thanks Miguel!