2 Replies Latest reply: Apr 3, 2015 3:33 PM by Antonio Caria RSS

    XLSX to QVD

    Kenny Hua

      Hello everyone,

       

      Actually, I try to create some QVD from XLXS and CSV. But I reach to a problem :

       

      ODBC connection failed

       

      I get my XLSX from a FTP and I want to put my futur QVD in my computer. (For a test before to send them to a FTP)

       

      XLSX:

      LOAD

        *;

      SQL SELECT

        *

      FROM [ftp://AAA:BBB@11.111.11.111/File/file_name.csv] (txt, codepage is 1252, embedded labels, delimiter is ';', no quotes);

       

       

      STORE XLSX into XLSX.qvd(qvd);

       

      Regards