Database to QVD using SQL?

Fri, 08 Jan 2016 14:12:34 GMT

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

Re: Database to QVD using SQL?

petter — Fri, 08 Jan 2016 18:12:36 GMT

The simplest form of load script is like this:

[TABLENAME]:

SQL

SELECT * FROM myTable;

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