Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcement: We have made updates to resolve a Page Not Found error. If you still get this error, please let us know in the Community Corner.
saumyashah90
Valued Contributor

How to connect QlikSense with MS Access Database?

I want to connect QlikSense with MS Access database...how can I do it?

1 Solution

Accepted Solutions
Partner
Partner

Re: How to connect QlikSense with MS Access Database?

Hi Samuya Shah,

select OLE DB connector in Data Connections than choose Jet4.0 driver (best for Access DB)

jet4.png

Then insert the directory where yout MDB is and the name of the DB:


driver.png


Now you can choose which table to load using the second button


3.png



Enjoy!


Regards,


Tiziano

7 Replies

Re: How to connect QlikSense with MS Access Database?

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

!.png

Partner
Partner

Re: How to connect QlikSense with MS Access Database?

Hi Samuya Shah,

select OLE DB connector in Data Connections than choose Jet4.0 driver (best for Access DB)

jet4.png

Then insert the directory where yout MDB is and the name of the DB:


driver.png


Now you can choose which table to load using the second button


3.png



Enjoy!


Regards,


Tiziano

Re: How to connect QlikSense with MS Access Database?

Hi Saumya,

If you got the answer from the post then close the thread by selecting appropriate answer for references.

Regards,

Anand

Employee
Employee

Re: How to connect QlikSense with MS Access Database?

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

Screenshot 2016-06-16 13.25.17.png

renisonc
New Contributor III

Re: How to connect QlikSense with MS Access Database?

You might want to try the  "Microsoft Office 15.0Access Database Engine OLE DB Provider (32 bit)" .. It worked for me.

QS_OLEDB_connection.JPG

adimiz123
New Contributor III

Re: How to connect QlikSense with MS Access Database?

I have no  "Microsoft Office 15.0Access Database Engine OLE DB Provider (32 bit)" in tha list.

How can I add it ?


Mercurion
New Contributor

Re: How to connect QlikSense with MS Access Database?

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