topic Re: MS Access database not listed as "Connect To Data Source" option in QlikView

MS Access database not listed as "Connect To Data Source" option

Anonymous — Tue, 04 Feb 2014 14:51:49 GMT

Hello my QlikView friends. I hope this is an easy one. I am trying to connect to an Access database from QlikView. When I press the 'Connect' button, the 'Connect To Data Source' box opens up. However, there is no option for Access database. I am running QlikView 11.0.11440.0 SR2 64-bit Edition (x64)

Re: MS Access database not listed as "Connect To Data Source" option

Anonymous — Tue, 04 Feb 2014 14:54:43 GMT

You can connect to Access database using ODBC. As far as I know, there is no 64-bit ODBC driver for access, so make sure to check "32-bit" box.

Re: MS Access database not listed as "Connect To Data Source" option

Anonymous — Tue, 04 Feb 2014 14:57:11 GMT

Michael, even when checking the '32 bit' check box, there is not option listed for MS Access. Any other ideas? Thanks.

Re: MS Access database not listed as "Connect To Data Source" option

Anonymous — Tue, 04 Feb 2014 15:00:42 GMT

Well, you have to create ODBC DSN first. And for that you need Access driver.

Re: MS Access database not listed as "Connect To Data Source" option

Luis_Cortizo — Tue, 04 Feb 2014 15:06:01 GMT

You should be able to connect to an Access database using the Jet 4.0 x32 OLEDB provider

Re: MS Access database not listed as "Connect To Data Source" option

luis_pimentel — Tue, 04 Feb 2014 15:07:16 GMT

After clicking the "Connect" button, make sure you have checked the "Show User's DSN" option. Then, if you have Microsoft Access installed, you will find de MS Access Database Option.

(sorry for the screenshot, it is in Spanish)

Hope that helps,

Luis.