Connection to a file that change number of sheets

[holguinmora]

Hi to all!!

On the next images a screenshots of a connection that change the number of sheets form time to time.

Any ideas on how to configure the connection so every time gets all the sheets?

Important to mention that on the last image a yellow segment that shows how the info finish. On the first column the las line is always a *

As always thank you very much for your help and Ideas!!!!!!

Sometimes I get 6 sheets

Sometimes I get 3 sheets

Always the last line of the firs column is *

any ideas?

[miskinmaz]

You can check the below mentioned solution
https://community.qlik.com/t5/New-to-QlikView/loading-all-sheets-data-from-excel/td-p/673784

[holguinmora]

Miskinmaz hi

I read all the info that you sent me but unfortunately the "ODBC CONNECT TO" is no longer available in Qlik Sense Desktop or in qlik sense Business Cloud as you can see in the next image, any other idea?

[holguinmora]

Is important to mention that the file is a HTM and not excel