topic Re: XLSX to QVD in QlikView

XLSX to QVD

Fri, 03 Apr 2015 10:24:37 GMT

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

prieper — Fri, 03 Apr 2015 18:16:18 GMT

Not quite clear depending the data, but believe that you should not use the SQL SELECT statement as you refer to an ordinary text-file.

LOAD * FROM .... should do

HTH Peter

Anonymous — Fri, 03 Apr 2015 19:33:53 GMT

SELECT's are only or ODBC / OLEDB connection to a Relational database.

Not for Excel, XML or CSV or any other File format.

However, You can have access to a Database on Excel...