Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
andres_corredor
Contributor III
Contributor III

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!

1 Solution

Accepted Solutions
andres_corredor
Contributor III
Contributor III
Author

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

View solution in original post

5 Replies
vlad_komarov
Partner - Specialist III
Partner - Specialist III

How are you doing it?

Did you create an ODBC connector and corresponding Qlik connector?

VK

brian_holborow
Partner - Contributor III
Partner - Contributor III

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
Contributor III
Contributor III
Author

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
Not applicable

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

cabc
Contributor
Contributor

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