Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Connection Issue to MS access data files into Qlik Sense Desktop?

I would like to add MS Access files into Qlik Sense but found connection error.  All are sitting on windows 7 64-bit computer but with 32-bit windows office.

Is it the correct way for Qlik Sense to connect to 'windows\sysWOW64\odbcad32.exe instead of the normal connection to 32-bit ODBC (under windows\system32\odbcad32.exe)?

Or it has another alternative?

Hope you can help out there.  Thank you.

4 Replies
dwforest
Specialist II
Specialist II

Access DB is on another PC than the one running Sense (Desktop or Server?).

Is the connection string in the form of a UNC that has been appropriately shared to the account attempting the connection?

Not applicable
Author

Access DB and Sense are sitting on the same desktop.  No connection string is set so far.

Now I changed installation 64-bit MS Access.  Same connection error occurred.

balabhaskarqlik

Try with  "Microsoft Office 12.0 Access Database Engine OLE DB Provider" option.

bsbernabe
Creator
Creator

Hi Monique,

     Have you try to connect your MS Access Data to ODBC first? before connect to Qlik Sense? if not yet try first,

     i hope it is helpful.