7 Replies Latest reply: Jul 7, 2014 6:41 AM by Gysbert Wassenaar RSS

    Load Multiple Excel Sheets *Without* ODBC Connection

    Matthew Bryant

      Hi All,

       

      I've been trying for a while now to loop through a list of sheets (JAN, FEB, ... , NOV, DEC), but I'm having issues loading more than one sheet. The following works, but as soon as I replace 'JAN' for 'JAN, FEB' I get the error 'Unknown file format specifier: FEB'. Is there a syntax nuance that I need to know or am I way off?

       

      SET i = JAN;

      FOR Each i in i;

       

        LOAD

        A,

        B

         FROM

         [DOC.xlsx]

         (ooxml, embedded labels, Table is $(i));

        

      NEXT