Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

loading data


Hi All,

    I have excel files stored in a folder(similar kind of data on monthly). now i want to read all these files in to a qvd

    How can i acheive this

    Thankz in advance

3 Replies
Not applicable
Author

Just load all excel files

like

table:

load

xl1;

concatentae

load

xl2;

concatenate

load xl3;

store table into c:\....\xl.qvd;

Not applicable
Author

Hi,

Load Concatenate this excel file with existing qvd and then store it.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

MyTable:

LOAD * from (ooxml, embedded labels, table is Sheet1);

STORE MyTable into MyTable.qvd;


talk is cheap, supply exceeds demand