Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

convert excel files and database tables to qvd

Hi, how can I convert excel files and database tables to qvd format without downloading software? Thanks.

20 Replies
engishfaque
Specialist III
Specialist III

Dear Rachel Boey,

Here is the two steps and easiest solution.

Same way you can convert excel files and database tables to qvd format without downloading any software.

Step 1:

---------

File > Edit Script > Data > Table Files > Select txt file > Finish.

Example:

---

CustomerSale:

LOAD Year,

     Sale

FROM

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Step 2:

---------

STORE CustomerSale into E:\QlikView\qvd\CustomeSaleFile.qvd;

Kind regards,

Ishfaque Ahmed