6 Replies Latest reply: Mar 9, 2016 7:05 AM by Onno van Knotsenburg RSS

    LOAD sam type of data from multiple xls files

    Johan Andersson

      Hi

       

      i have load statement as follows:

       

      LOAD

       

           A.LEVTIDPKT as PlanDelTime,

           A.ARTNRCH as EngVer,

           PROPVER

      FROM

      JA_2012.xlsx

      (ooxml, embedded labels, table is ja_sim);

       

      i have in the same folder files with same nameing on sheets

      JA_2013.xlsx

      JA_2014.xlsx

      JA_2015.xlsx

      how to make the load statmemnet work to read all data from the files?