I want to connect QlikSense with MS Access database...how can I do it?
Use Create New Connection option in the Data Connections >> and then use ODBC or OleDB connection for that.
See the attached image
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
If you got the answer from the post then close the thread by selecting appropriate answer for references.
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 ?
Retrieving data ...