Store Data into Excel

[#1]

Hi,

I have small data. There's data transformation involved & I would like to do incremental load to QVD every month

Is it possible to store all the data into excel file besides QVD?

Reason:

- To backup all the data if anything happen

- It's easy to do modification if we load data wrongly

[Michiel_QV_Fan]

You can store to TXT as an alternative to QVD.

Just use 'store .. into ... .txt (txt)';

If you do a correctly structured insert, update and delete incremental load the data will be corrected during reload.

[#3]

Thanks Michiel but if i store it into .txt, i can't easily modify it and reload it again

Why i need to keep track? Because the data structure is not fix all the time