Load Excel files with multiple sheets

[#1]

Hi everybody! I need load some Excel files and each one with sheets that have differents names. I have seen diferents topics related with this but I don't understand. I don't have a conection with a SQL database. I attach an example of Excel file.

Thank you!

[Roop]

http://community.qlik.com/docs/DOC-4452 gives a very good example on how you do this in a script. It should be simple to follow

Hope this helps

[#3]

Yes, I have seen it, but the problem, is that in my case all sheets have differents name! Buenos Aires, Catamarca, etc.

I used this topic when de sheets names are numerations or similar.

[maxgro · Accepted solution]

try here

Re: Loading from multiple Excel files and multiple sheets

[#5]

It works now! I had to create a conection odbc to Excel files.Thank you!