how to make qvd for multiple source file

[riishabhz]

my script is this as you can see i have two sql table and one excel table

i want to convert this into .qvd format so i want to make 3 qvd  seprately which is 2 for sql and 1 for .csv

i tried but it didnt worked so i deleted the script .

what should i do now?

dohead:
SQL SELECT *
FROM ETPStoreV55.dbo.DOHead;

doline:
SQL SELECT *
FROM ETPStoreV55.dbo.DOline;

exceltable:
LOAD Key,
Ncode,
StoreName,
Partner,
City,
Region,
Brand,
Gender,
Cat,
SubCat,
Theme,
Fashion,
StyleNO,
Color,
GradeCount,
BGrade,
PGrade,
Count,
MRP,
OrderQty,
Recd_Qty,
Sold_Qty,
[ST Ord],
[ST Rect],
Cost,
MRLVAL,
DISC,
TAX,
NetAMt
FROM
[C:\Users\r.bhardwaj\Desktop\19P_BUY.xlsx]
(ooxml, embedded labels, table is Sheet1);

[andrei_delta · Accepted solution]

Hi,

Store  dohead into [C:\Users\r.bhardwaj\Desktop\dohead.qvd];

Store  doline into [C:\Users\r.bhardwaj\Desktop\doline.qvd];

Store  exceltableinto [C:\Users\r.bhardwaj\Desktop\exceltable.qvd];

or you can use this kind of store:

store * from doline  into [C:\Users\r.bhardwaj\Desktop\doline.qvd]; 

etc.

hope it helps,

Andrei

[riishabhz]

thanx a lot it worked 

[andrei_delta]

With pleasure!