Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Syntaxis error in load script when loading from Excel sheet

Hello!

I have made an ODBC with an Excel worksheet. Qlik Sense recognises the ODBC and I can select data from the worksheet, but when I try to load the script, I get an error, saying that there is a syntaxis error in my "FROM component". The syntaxis in the FROM component looks like this:

FROM KTV_Q4_2016_SO.xlsx`.`Resultaten$` ; 

Seems okay to me. Does anyone has a clue what goes wrong here?

Thanks!

Regards,

Hugo

4 Replies
kaushiknsolanki

Hi,

Try removing the quotes.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Not applicable
Author

Hi Kaushik,

Thank you for your suggestion! It does not work, however.

vishsaggi
Champion III
Champion III

Try this?

FROM "Yourexcelpath\KTV_Q4_2016_SO.xlsx"."Resultaten$" ;

Chanty4u
MVP
MVP

try to rename the .Xlsx file and reload again