Discussion Board for collaboration on QlikView Scripting.
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)
FROM [ftp://AAA:BBB@220.127.116.11/File/file_name.csv] (txt, codepage is 1252, embedded labels, delimiter is ';', no quotes);
STORE XLSX into XLSX.qvd(qvd);
Go to Solution.
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
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...