Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem executing a loading script on QV

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

0 Replies