how to load accdb file into QVW - Qlik Community

Report Inappropriate Content · ‎2013-03-07

i am having a accdb file i have to load it to qlikview how can i do it

jagannalla · ‎2013-03-07

Go to Edit Script -> in buttom there will be Data tab -> Click on Force 32 bit check box -> Now choose OLE DB from Data source -> click on Connect button ->Choose Microsoft Jet 4.0 OLE DB Provider -> Next -> Choose your acc db file -> Ok

Now you can choose tables of acc db from Select button of Data tab

Report Inappropriate Content · ‎2013-03-07

it is not working

kaushiknsolanki · ‎2013-03-08

HI,

will you tell us what are the steps you are trying.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2015-10-13

I connect to an Access 2010 (x86) database this way:

1. Create System-DSN with 32-Bit ODBC driver manager:

c:\windows\SysWOW64\odbcad32.exe

Use "Microsoft Access Driver (*.mdb, *.accdb)" !

2. In Script-Editor use: ODBC, force 32-Bit

3. Click on "Connect", select your ODBC System-DSN

4. Click on "Select", select table and fields