Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Create 32 Bit Access Connection

I have seen a couple of threads on this and I don't understand the answers provided. If I am trying to connect to an Access database (32 bit Office 2010, .mdb file), which "provider" do I use in the large dropdown list of options when creating the database connection? 

1 Reply

Re: Create 32 Bit Access Connection

You should create a system data source using C:\Windows\SysWoW64\odbcad32.exe. Then the data source will appear in Qlik Sense.

See more on The Great ODBC Confusion.

This post is about QlikView, but most of the info is relevant also for Qlik Sense.