1 Reply Latest reply: Dec 14, 2016 2:45 PM by Liron Baram RSS

    load multiple excel files

    Robert Winkel

       

      I have multiple excel files that are the exact same, columns and headings all the same and same order.

       

      All files only have one sheet but the sheet name is different.

       

      Below is my script I am trying to get to work, it works with a text file but not excel.

       

      What am I doing wrong?

       

       

       

       

      LOAD

       

          OrderDate,

       

          OrderNumber,

       

          FacilityName,

       

          FacilityID,

       

          RouteNumber,

       

          ScheduledLeaveTime,

       

          ActualLeaveTime

       

      FROM [lib://HealthEX (pharmore_rwinkel)/*.xlsx]

       

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