QlikSense Not getting a specific Connection Driver under OLEDB
Article Number: 000026362 | Last Modified: 2016/12/15
In QlikSense I am trying to create connection using OLEDB driver : "Microsoft office 12.0 access database engine OLE DB Provider", However cannot see that in OLEDB list. I can see that driver in Qlik View, but not in QlikSense.
Using JET 4.0 driver or creating a MS Access DSN and using in Qlik Sense desktop in version 3.0 loads tables from MS Access database.
Creating DSN steps:
1. Create System-DSN with 32-Bit ODBC driver manager:
Use "Microsoft Access Driver (.mdb, .accdb)" !
2. In Script-Editor use: ODBC, force 32-Bit
3. Click on "Connect", select your ODBC System-DSN
4. Click on "Select", select table and fields