Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
You can't store to an excel file. Only output to qvd and text files (like csv) are possible.
store efa_asset into $(DirDataQVD)efa_asset.csv (txt, delimiter is ',');
If you need to dump data from a database directly from the database into excel files then use an ETL tool that supports writing to Excel.