
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How connect a MS Access DB to Qlik Sense
Hi,
I am trying to connect to a MS Access DB from QlikSense without success. I am getting error when I test the connection. Any clue for this?
Thank you!
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks guys for your answer, it is already solved I was using a DB with extension .accdb. I needed to install which apparently does not work with all possible connector we have available, so I just selected 'Microsoft Officer 12.0 Access Database Engine OLE DB Provider', it is working now!
Cheers,
Andres


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How are you doing it?
Did you create an ODBC connector and corresponding Qlik connector?
VK

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Andres
there seems to be a bug in some versions of Qlik Sense that makes it look as if a connection has failed to an Access database when you 'Test' the connection - but in fact the connection has worked fine. I suggest that you ignore the test message, and try to actually use the connection to extract some data - it may work fine.
Hope that helps.
Please mark this as helpful / correct if your question has been answered to your satisfaction
Brian

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks guys for your answer, it is already solved I was using a DB with extension .accdb. I needed to install which apparently does not work with all possible connector we have available, so I just selected 'Microsoft Officer 12.0 Access Database Engine OLE DB Provider', it is working now!
Cheers,
Andres

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What did you put as path, i tried the same thing and it gives me an error.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey guys, I worked it with a Qlik Consultant and he told me to install this file from Microsoft, which include the 'Microsoft Officer 12.0 Access Database Engine OLE DB Provider' connector!
https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255
