Databases Reference
In-Depth Information
Extracting data from MS Access
Our first example will demonstrate how to extract data from an MS Access database.
It will be a good example since the connection process is very similar to that used
when connecting to most major DBMSs. We will be using one of the drivers discussed
in the previous section, and covering the steps required in the entire process.
Before continuing, make sure a database file named
Dimension
Tables.mdb
is in the
Data Files\MDBs
folder. If not,
proceed to create the folder, if necessary, and copy the file.
Configuring the driver
Drivers for MS Access databases are often installed, by default, with the Windows
OS. The default drivers are built for 32-bit architectures, but that won't be a problem
for us since, as pointed out earlier, both editions of QlikView can make use of any
32-bit driver.
Connectivity to an MS Access database is provided by Microsoft either through
ODBC or OLE DB drivers. At this point, we must decide which of the two types of
drivers we want to use. Since the connection setup via the OLE DB driver is more
straightforward, we will opt for that method. However, we will take a moment to
briefly describe the configuration process for ODBC drivers.
The following process is not necessary when using OLE
DB drivers, and, for the purpose of our example, we can
skip these steps.
How to set up an ODBC connection
In order to create the ODBC configuration, we need to go to the
ODBC Data Source
Administrator
window. Access this window via
Control Panel
|
Administrative
Tools
|
Data Sources (ODBC)
.
Accessing a 32-bit ODBC Data Source Administrator from a
64-bit machine
If you are using a 64-bit machine and need to configure a 32-bit ODBC
driver, you will need to access
ODBC Data Source Administrator
from a different location. Go to the
%systemdrive%\Windows\
SysWoW64
folder and launch the
Odbcad32.exe
file. Otherwise,
only 64-bit drivers will be available to configure.
