2 Replies Latest reply: Feb 5, 2016 12:51 PM by Peter Cammaert RSS

    Error: File extdata.cpp, Line 2903.

    Pulkit Thukral

      The following script is throwing error as - Error: File extdata.cpp, Line 2903.

      What could be the solution to this.




      CONNECT TO [Provider=Microsoft.ACE.OLEDB.12.0;Data Source=open.xlsx;Extended Properties="Excel 8.0;"];

       

      tables:

      SQLtables;

      DISCONNECT;

       

       

      FOR i = 0 to NoOfRows('tables')-1

       

          LET vsheetName = purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39));

       

      Sheets:

      LOAD *,

      '$(vsheetName)' as Sheet

       

      FROM

      [open.xlsx]

      (ooxml, embedded labels,Table is [$(vsheetName)]);

       

       

      NEXT

       

      DROP TABLE tables;  // The table list is no longer needed