Discussion board where members can get started with QlikView.
Here is a quick view on how to load data from an ODBC data source.
Thank you. I'm trying to connect to access (accdb) file and I see only mdb file in the list of User data sources in control panel. Maybe I need to post this issue in a different forum!
When you connect what do you see in the Database Name, like below
If you only see .mdb, change it so it looks like above and then see if that Access DB is available
Thank you again Alan. I installed the microsoft access database engine 2010 and now able to see both mdb and accdb as displayed in your picture. Problem solved. Thanks!
The issue previously may have been that you were using a 64 bit driver and the old version of Access required a 32 bit driver to be used. There is a checkbox in QlikView to force 32 bit when this is the case.