connected to access mdb but not able to see tables

[#1]

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];

[#2]

figured out.

use Microsoft.Jet.OLEDB.4.0

[settu_periasamy]

Hi,

After creating the ODBC, you need to select the Tables.

See the below screen shot.

[Anonymous]

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

[Anonymous]

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?

[Anonymous]

check this video as well:

Qlikview How to import an Access Database to Qlikview RFB 11 - YouTube