16 Replies Latest reply: May 23, 2016 8:15 AM by Tamil arasu RSS

    Loading Excel Files from multiple Folders

    Ridhaa Hendricks

      Hi There


      I need to be able to load all files from all folders within a specific folder.


      I have tried the below piece of script. but when running it returns no data.


      I have the folder structure like this.




      my file name is TestData.xlsx and is in the Jan folder


      I need to be able to pull all the files from my Test folder no matter the year no matter the month .



      let vAllPath='C:\Users\Rido\Desktop\Test\*.xlsx';

      for each File in filelist (vAllPath)

      LOAD Cars,
      ooxml, embedded labels, table is Sheet1);

      next File



        Any Assistance is appreciated