generating QVD from xls

[marksmunich]

Hello,

How to create a QVD file from .xls file.

what script must be used to perform this task.

Mark

[Gysbert_Wassenaar · Accepted solution]

Just a load and a store command:

Table1

Load * from ...myexcelfile...;

Store Table1 into myqvdfile;

[Sokkorn]

Hi,

Suppose that your qvw and excel in the same directory.

[ExcelData]:

Load * from MyExcel.xlsx;

Store [ExcelData] Into MyQVD.qvd;

Regards,

Sokkorn

[#4]

table1:

load

id,

name,

address

from table1;

store table1 into D:\ table1.qvd;