3 Replies Latest reply: Oct 27, 2015 2:01 PM by Oleg Troyansky RSS

    Load multiple Excel-Files with multiple Sheets

      Hello Community,

       

      i searched for this context and got many results with the "For" Loop. The problem is that i cant adapt that because of my lack in programming skills. So what i wanted to ask is the possibility of Loading Data with the same "Header" from different Sheets/Files.

       

      Example:

       

      i have 2 Excel Sheets with same name, except the numbers at the end:

      - Data_02.xls

      - Data_33.xls

       

      They all got the same header, so right now iam doing 2 times:

      LOAD [ColumnA1],

                [ColumnA2],

                ...

      FROM

      [C:\...\Data_02.xlsx]

      (ooxml, embedded labels, table is [detail]);

       

      LOAD [ColumnA1],

                [ColumnA2],

                ...

      FROM

      [C:\...\Data_33.xlsx]

      (ooxml, embedded labels, table is [detail]);

       

      Is there a possibility to simply put the same "Load-statements" on one "FROM-Statement" ?

       

      for excample:

      FROM

      [C:\...\Data_33.xlsx], [C:\...\Data_02.xlsx]

      (ooxml, embedded labels, table is [detail]);

       

      Thanks in advance !