how to create ODBC connection in qliksense

[jayminmistry]

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

[QFabian]

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 :

https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/DataSource/ODBC.htm