Database to QVD using SQL?

[#1]

I'm wanting to be able to run a SQL statement against an ODBC connection to bring back data that I can then put into some QVD files.

I have been trying to do it like this so far:

TABLENAME:

SQL statement............

and then:

STORE TABLENAME INTO filelocation

What is the correct way of doing this? Any help much appreciated

[petter · Accepted solution]

The simplest form of load script is like this:

[TABLENAME]:

SQL

     SELECT * FROM myTable;

STORE [TABLENAME] INTO "C:\USERS\yourID\Documents\TABLENAME.QVD" (QVD);