Skip to main content
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
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Try removing the quotes.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
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