Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

XLSX to QVD

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

Tags (2)
1 Solution

Accepted Solutions
prieper
Honored Contributor II

Re: XLSX to QVD

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

2 Replies
prieper
Honored Contributor II

Re: XLSX to QVD

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

bestofwest
Contributor II

Re: XLSX to QVD

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...

Community Browser