Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I able to connect the Ms Access mdb file , but after reload the script there is no tables for me to add.
Thanks
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='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
ODBC CONNECT32 TO [MS Access Database;DBQ=Z:\RF TPUT\RF Tput.mdb];
figured out.
use Microsoft.Jet.OLEDB.4.0
Hi,
After creating the ODBC, you need to select the Tables.
See the below screen shot.
see this for connection:
OLE DB/ ODBC connection to data sources in Qlikview — Mindmajix
After making the connection, then click on select and load your required tables:
see the attachment..
If your Connecion was successful and after the Select command from QV, if still you are not getting tables, check whether your MS Access db contains tables?
check this video as well:
Qlikview How to import an Access Database to Qlikview RFB 11 - YouTube