Qlik sense Desktop - How to load a MS Access file?

[Anonymous]

Hi everybody,

Really need to understand how to load a MS Access file on Qlik SENSE.  I'm trying to use this path: 

New >> OLE DB >> Provider: Microsoft OLE DB Provider for ODBC Drivers (32-bit) >>  Data source: file's path from my PC >>  When I click on "load database",  It doesn't displayed anything. 

Thanks to anybody who knows how to help me.

G.

[DavidŠtorek]

Hi,

fo MS Access I would use Microsoft Office 12.0 Access Database Engine OLE DB Provider.

If you selected Microsoft Office 12.0 Access Database Engine OLE DB Provider, enter the file name of the Access database file, including the full file path:

C:\Users\{user}\Documents\Qlik\Sense\Apps\Tutorial source files\Sales.accdb

Than fill in Username and password (if any)

Click test connection, if successful than give it some name and click create.

That is it 😉

[Thiago_Justen_]

You can also create an ODBC connection even your database is MS Access.