Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

connected to access mdb but not able to see tables

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

5 Replies
Not applicable

Re: connected to access mdb but not able to see tables

figured out.

use Microsoft.Jet.OLEDB.4.0

Re: connected to access mdb but not able to see tables

Hi,

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

See the below screen shot.

Capture.JPG

balrajahlawat
Esteemed Contributor

Re: connected to access mdb but not able to see tables

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

balrajahlawat
Esteemed Contributor

Re: connected to access mdb but not able to see tables

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?

balrajahlawat
Esteemed Contributor

Re: connected to access mdb but not able to see tables

Community Browser