Hello everyone,
I'm developing a little Qlikview application, and since one hour I'm trying to load some data from an MS Access database, but I obtain an error I can't Resolve, can anyone help?
SET ThousandSep=' ';
SET DecimalSep=',';
SET MoneyThousandSep=' ';
SET MoneyDecimalSep=',';
SET MoneyFormat='# ##0,00 €;-# ##0,00 €';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';
SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';
ODBC CONNECT32 TO [TR_CLUB;DBQ=C:\Users\Toshiba\Desktop\TR_CLUB.mdb];
SQL SELECT *
FROM Sales
INNER JOIN Invoice_Line on Sales.inv_id = Invoice_Line.inv_id
;
And the error is :
Échec de lecture ODBC
SQL SELECT *
FROM Sales
INNER JOIN Invoice_Line on Sales.inv_id = Invoice_Line.inv_id