Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to connect QlikSense with MS Access database...how can I do it?
Hi Samuya Shah,
select OLE DB connector in Data Connections than choose Jet4.0 driver (best for Access DB)
Then insert the directory where yout MDB is and the name of the DB:
Now you can choose which table to load using the second button
Enjoy!
Regards,
Tiziano
Hi,
Use Create New Connection option in the Data Connections >> and then use ODBC or OleDB connection for that.
See the attached image
Regards
Anand
Hi Samuya Shah,
select OLE DB connector in Data Connections than choose Jet4.0 driver (best for Access DB)
Then insert the directory where yout MDB is and the name of the DB:
Now you can choose which table to load using the second button
Enjoy!
Regards,
Tiziano
Hi Saumya,
If you got the answer from the post then close the thread by selecting appropriate answer for references.
Regards,
Anand
Hi. Have you recently tried that? I cannot get over the "New connection (OLE)" dialog, which seems to have worked for you. I am using Sense 2.2
You might want to try the "Microsoft Office 15.0Access Database Engine OLE DB Provider (32 bit)" .. It worked for me.
I have no "Microsoft Office 15.0Access Database Engine OLE DB Provider (32 bit)" in tha list.
How can I add it ?
Dear All... same problem here.... I even have to following option:
"Microsoft Office 16.0 Access Database Engine OLE DB Provider(32-bit)"... not working... ;((
as the others have stated, you want to use OLE DB coonnection, (odbc will require it to be set up on the server).
Next, eventually you will want this to be used by users in a stream. The connection has to point to a location that the Qlik server can access. the connection to your local C drive, might work for development but it will not work when the app is published into a stream.
Hello,
I can't find the OLE connector or ODBC in the list of my possible connections. Is there a limitation on my profile ?
Thanks