topic Re: load file excel in QlikView https://community.qlik.com/t5/QlikView/load-file-excel/m-p/1269676#M399537 <HTML><HEAD></HEAD><BODY><P>You can load all the excel files using a * as wildcard:</P><P></P><P>MyData:</P><P>LOAD * FROM [<STRONG>D:\ExcelFiles\*.xlsx</STRONG>] (ooxml, embedded label, table is Sheet1);</P><P></P><P>Or you can use a loop: <A href="https://community.qlik.com/thread/62449">loop through to load all files from a folder and its subfolders?</A></P></BODY></HTML> Fri, 02 Dec 2016 11:25:15 GMT Gysbert_Wassenaar 2016-12-02T11:25:15Z load file excel https://community.qlik.com/t5/QlikView/load-file-excel/m-p/1269675#M399536 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Hello,<BR />I would like to know the best solution to load excel files every month at once, each file contains the same fields, just the values ​​that change each month.<BR />Thank you for your help.<BR />Best regards </SPAN></P><P><SPAN lang="en">Maurice<BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P></BODY></HTML> Fri, 02 Dec 2016 11:18:52 GMT https://community.qlik.com/t5/QlikView/load-file-excel/m-p/1269675#M399536 MauriceLudo 2016-12-02T11:18:52Z Re: load file excel https://community.qlik.com/t5/QlikView/load-file-excel/m-p/1269676#M399537 <HTML><HEAD></HEAD><BODY><P>You can load all the excel files using a * as wildcard:</P><P></P><P>MyData:</P><P>LOAD * FROM [<STRONG>D:\ExcelFiles\*.xlsx</STRONG>] (ooxml, embedded label, table is Sheet1);</P><P></P><P>Or you can use a loop: <A href="https://community.qlik.com/thread/62449">loop through to load all files from a folder and its subfolders?</A></P></BODY></HTML> Fri, 02 Dec 2016 11:25:15 GMT https://community.qlik.com/t5/QlikView/load-file-excel/m-p/1269676#M399537 Gysbert_Wassenaar 2016-12-02T11:25:15Z