6 Replies Latest reply: Jun 10, 2010 6:08 AM by Annette Søgaard RSS

    Saving Excel (xlsx) data to a QVD - Debug reports: Error: File .\extdata.cpp, Line 1826

      Hello, We are new to QlikView. Have a very large Microsoft Excel workbook. Tested smaller workbook and it works but fails with a large one. Object: creation of a qvw that created a qvd file as the data source. The statement used in the script's Main tab is below. Do you have a solution for this? Thanks in advance for your feedback.

      Ricardo Pous -ricardo.pous@pioneer.com -Pioneer Hi-Bred International Inc. 1.515.270.3543

      MyTable:

      Load *

      from [c:\ProgramData\QlikTech\Documents\RowsAndColumns.xlsx] (ooxml, embedded labels, table is Sheet1);

      Store *

      from MyTable into [c:\ProgramData\Qliktech\Documents\RowsAndColumns.qvd];

      Drop table MyTable;

      Debug reports: Error: File .\extdata.cpp, Line 1826 MyTable: LOAD * FROM [c:\ProgramData\QlikTech\Documents\RowsAndColumns.xlsx] (ooxml, embedded labels, table is Sheet1)