Exporting Data from a QVD File

[#1]

Hi Guys,

Ok so basically i have recieved a bunch of QVD files at the end of the day these need to be automated to export into A MS SQL warehouse, is there a way to this automatically, or even if i can export it to Excel/Flat file etc i will be able to do the transformation from there.

Thanks

[fosuzuki]

You can load the QVDs, do the transformation and store them into text files as CSV.

mytable:

LOAD  *

FROM myfile1.qvd (qvd);

store mytable into myfile2.txt (txt);