Qlikview Import Microsoft Access Data

I don’t use Microsoft Access all too often these days, but I recently received a request to import data from a MS Access database into Qlikview.  I didn’t think much of the request until I started to work on the Load Script.  It took me a while to figure it out!  So I thought I would create a post detailing the process, in hopes this will help someone else who might be struggling like I did.

Setup

Here are the steps to accomplish this task:

I am using Access 2013 and Qlikview Personal Edition Version 11.20.12235.0 SR5 64-bit Edition (x64)

Create a Qlikview App and save the file.  The first thing you should check is whether or not you have the correct Microsoft Access ODBC driver installed.  Go to the following:

In the Edit Script window, click on Tools –> ODBC Administrator 32 bit…

Qlikview Import Microsoft Access Data

In the “User DSN” tab, click on “Add” and make sure you have the following driver installed:

Microsoft Access Driver (*.mdb, *.accdb)

Qlikview Import Microsoft Access Data

If you don’t see this, you can download it from the following location:

Microsoft Access Database Engine 2010 Redistributable

Select the “Microsoft Access Driver (*.mdb, *.accdb), Name the Data Source and click “Select” in the Database: section.  Navigate to where your MS Access database is saved and select it.

Qlikview Import Microsoft Access Data

Back in the Qlikview “Edit Script” window, select “ODBC” in the drop-down and make sure to check box for “Force 32 Bit”, then click the “Connect” button

Qlikview Import Microsoft Access Data

Select the ODBC Data Source you just setup, then click “OK”.  Make sure to check the box “Show User DSNs” in case it isn’t already checked, so these Data Sources appear

Qlikview Import Microsoft Access Data

You will now see the connection in your “Edit Script” window.  Next, click on the “Select” button in the Database section

(Click on Image to Enlarge)

Qlikview Import Microsoft Access Data

You will now see all the Tables and Queries in your MS Access Database (make sure to check box for “Views” in order for the Queries to appear)

Qlikview Import Microsoft Access Data

Select the objects you would like to import and click OK.  Now your “Edit Script” window will look something like this:

(Click on Image to Enlarge)

Qlikview Import Microsoft Access Data

Click on “OK”, then Reload the data.

Qlikview Import Microsoft Access Data

That should do it, your MS Access data is now imported into your Qlikview application for further use!

 

Additional Content

Check out more examples by visiting my Home Page

Here you will find topics covering  Qlikview  SQL Server  Excel VBA

 

 

Leave a Comment