how to create ODBC connection in qliksense

jayminmistry · ‎2021-03-18

I want to access MS Access DB from QlikSense but don't know how to create ODBC connection in qlik sense

QFabian · ‎2021-03-18

Hi @jayminmistry , here is a little guide to connect to MS Acess, using OLE DB instead (simpler than) ODBC.

1.-Go to Data Load Editor

2.- Create a new connection

3.- Choose OLE DB

4.- Choose Microsoft Jet 4.0.....

5.- Write the path and Ms Access file, put a Name, and press Create

6 .- Use it from Data connections :

to create the connection line

to view tables from the source and load them

Adittionally, here is the link from Qlik Help Web Site :

QFabian