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: 
saumyashah90
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
tizianomaggi
Partner - Contributor
Partner - Contributor

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

10 Replies
its_anandrjs

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

tizianomaggi
Partner - Contributor
Partner - Contributor

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

its_anandrjs

Hi Saumya,

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

Regards,

Anand

ChristofSchwarz
Partner Ambassador
Partner Ambassador

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

renisonc
Partner - Contributor III
Partner - Contributor III

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

adimiz123
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 ?


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

Ken_T
Specialist
Specialist

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. 

Emmanuelle
Contributor II
Contributor II

Hello,

I can't find the OLE connector or ODBC in the list of my possible connections. Is there a limitation on my profile ?

ConnectorsList.JPG

Thanks