Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
karimzdn
Contributor
Contributor

How to connect Qlik Sense serverwith accdb

Hello everyone 🙂

 

I would like to establish a connection between Qlik sense Enterprise and an Access database to display tables, but I can't!

I used to use an ODBC connection on Qlik View, but it doesn't seem to work here!

I tried to create a new OLE DB connexion with  :

- Microsoft Office 12.0 Access Database Engine OLE DB Provider and 

- Microsoft jet 4.0 OLE DB Provider 

but it doesn't work 

 

can someone help me ?

Labels (3)
1 Reply
Ray_Strother
Support
Support

Hello,
Have done the following :
1. Add a System DSN on your machine with a Microsoft Access Driver
2. Select your MS Access file
3. Create an ODBC connection in your Qlik sense
4. Made the account has permission in the MS Access Database

https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-connect-QlikSense-with-MS-Access-Database/td-...
Thanks