Hi there
I am working on a new laptop with Windows 10 / MS Office 365 / Qlik Sense Desktop (February 2019) installed. I do not appear to be able to connect Qlik Sense to data in an existing MS Access 365 (accdb) database - created using the latest version of Office.
The issue is that the OLEDB connector only contains the Microsoft Jet 4.0 OLE DB Provider and I am pretty sure that the new versions of Access are 64 bit and do not use "Jet" (though I am not an expert in this)
I have searched this forum and other web resources about how to connect to Access - and it appears that most posts on this subject relate to older versions of access (e.g. 2010). I suspect that I need an updated driver or redistributable (possibly from Microsoft) in order to do so (but don't really want to install things unless I am sure it is the right thing to do). I imagine that this is a fairly common requirement, so I think that an answer to this would be beneficial for many people.
Thanks in advance for any suggestions.