How Charge an ACCESS database on Qlik

[#1]

Hi,

Do you know how to connect an Acces database to Qlik creating an ODBC connexion ?

Thanks ,

Laure

[JonnyPoole · Accepted solution]

I do  ! 

First go to the control panel in windows -> Administative Tools -> ODBC Connections

Create a new system DSN  (user DSN will allow only your current windows user to access it) and choose the microsoft access driver . Then browse to the access database you want to use.  You need microsoft access components installed on the machine to have the right driver.  The DSN will be created with a name of your choice remember that name.

Once the DSN is created come back to Qlik Sense, open or create a new app.  Go to the 'Data Load Editor'.  On the right side create a new connection (Select ODBC) and enter the name you remember from above.  Thats about it.  Now you can select the 'check mark' under the ODBC connection on the right to select tables etc...

[#3]

Thanks Jonathan

i get back to you if I have other problem!

Laure