We are going to look at getting data from the QlikView data file and the MS Access database.
- For this, let's go to QlikView. We will use the application that we worked on in the previous section, containing the data we imported from the .csv file. We will open the Edit Script window to change our data source.
- For accessing data from MS Access, we will go to the Database section, choose ODBC for MS Access, and ensure that Force 32 Bit is selected. After that, you need to click on Connect.... This leads to the following window:
- In this window, we need to choose the MS Access Database option and click on OK.
- Once you click on OK, you will need to select your folder where the database is present, as shown here:
- After the correct database has been selected, we can go ahead and click on OK. This leads to the addition of the CONNECT32 statement...