Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

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
Highlighted
Partner
Partner

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

View solution in original post

8 Replies
Highlighted

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

Highlighted
Partner
Partner

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

View solution in original post

Highlighted

Hi Saumya,

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

Regards,

Anand

Highlighted
Employee
Employee

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

Highlighted
Partner
Partner

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

Highlighted
Contributor III
Contributor III

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

How can I add it ?


Highlighted
Contributor II
Contributor II

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

Highlighted
Contributor III
Contributor III

as the others have stated, you want to use OLE DB coonnection, (odbc will require it to be set up on the server).

 

Next, eventually you will want this to be used by users in a stream. The connection has to point to a location that the Qlik server can access. the connection to your local C drive, might work for development but it will not work when the app is published into a stream.