How connect a MS Access DB to Qlik Sense

[andres_corredor]

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!

[vlad_komarov]

How are you doing it?

Did you create an ODBC connector and corresponding Qlik connector?

VK

[brian_holborow]

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

[andres_corredor · Accepted solution]

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

[Anonymous]

What did you put as path, i tried the same thing and it gives me an error.

[cabc]

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