Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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)

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

5 Replies
Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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

Luis_Cortizo
Former Employee
Former Employee

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

Jet_OLEDB.png

luis_pimentel
Partner - Creator III
Partner - Creator III

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.