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;







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