1 Reply Latest reply: Aug 11, 2016 4:07 AM by Gysbert Wassenaar RSS

    Load script data from SQL and store them in an xls(x)

    Christian Wylezol

      Hi,

       

      we Need to prepare an ERP-Implementation and have some issues with exporting data into excel

      Does someone of you knows a way to load data directly from the database and store them into an excelfile?

      Today we are loading like below and it works.

       

      Now we Need additionally a load into Excel.

      But we have a second challenge: The first 60.000 entries go into Table 1, the next 60.000 entries go into Table 2 and so on

      (If we create a table and Export to Excel it has more than 1.2 Million entries)

       

      efa_asset:
      LOAD
      //Index der CODA-Tabelle
      ...
      ;
      SQL SELECT *
      FROM CODA."EFA_ASSET"
      WHERE CMPCODE like '$(varCMPCODE_SQL)'
      //AND DELDATE is null
      ;

      store efa_asset into $(DirDataQVD)efa_asset.qvd; (This should be adapted to load it into an Excel-File)

       

      Example:

       

      store efa_asset into $(DirDataQVD)efa_asset.xlsx;