Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

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
Champion III
Champion III

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

View solution in original post

5 Replies
Champion III
Champion III

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.

Creator
Creator

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

Champion III
Champion III

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

View solution in original post

Employee
Employee

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

Jet_OLEDB.png

Partner
Partner

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.