6 Replies Latest reply: May 3, 2016 8:33 AM by Gysbert Wassenaar RSS

    Load a named table from Excel

    Jeff Robertz

      I am trying to load a named table from Excel but can't figure out the script to achieve this.

      Can someone help me?

      The named Table is called Personnel and appears on Sheet1

       

      LOAD *

      FROM [lib://FIlename.xlsx]

      (ooxml, embedded labels, table is Personnel);

       

      Thanks a lot in advance.