Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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...