topic Re: How to Connect MS Access 2010 in QlikView

How to Connect MS Access 2010

Thu, 29 Aug 2013 07:05:31 GMT

Hi,

I am following the Developer training notes I have on how to load a database into Qlikview - I select OLE DB, then MS JEt 4.0 OLE DB but when I browse the network to select my file Qlikview does not recognise my database as a databse. I assume that this is because I have a newer version of Access. Does anyone know what I should select instead?

Thanks,

Janet

Re: How to Connect MS Access 2010

Thu, 29 Aug 2013 07:09:07 GMT

I have noticed that Qlikview searches for files ending in .mdb and mine are .accdb

Re: How to Connect MS Access 2010

Siva_Sankar — Thu, 29 Aug 2013 07:21:38 GMT

http://www.sagebasis.com/Blogs/how-to-access-mdb-file-of-microsoft-access-database-from-qlikview/

Re: How to Connect MS Access 2010

Thu, 29 Aug 2013 07:26:31 GMT

Many thanks. I also found this which worked for me.

Jean-Pierre Bakhache Jan 13, 2012 4:28 PM (in response to dhborchardt)

When setting up the connection in the script window, choose ODBC and check the "Force 32 Bit" flag then click Connect. You should get an "MS Access Database" in the Data Sources list (check the "Show User DSNs" flag if necessary). Then select your database and you'll end up having in your script a connection string as below:

ODBC CONNECT32 TO [MS Access Database;DBQ=C:\USERS\TEST\Desktop\Database1.accdb];

You can then click on "Select..." and pick your table from the database.

Re: How to Connect MS Access 2010

Thu, 29 Aug 2013 09:13:10 GMT

You need to setup ODBC

Access this window via Control Panel | Administrative

Tools | Data Sources (ODBC).

Once in the ODBC Data Source Administrator window, go to the System DSN

tab so the configuration we set is visible for any user of the machine, and then

click on Add…

The Create New Data Source window appears, which is where you will be able to

select the driver we want to use (select microsoft access driver)

After clicking on Finish, the configuration window will appear. Depending on the

driver you select, the configuration and parameters required for the connection

will vary. However, the configurations for almost all drivers on this, and all of the

following dialog windows, are very simple with self-explanatory fields.

After configuration, an ODBC connection can be used from QlikView in the same

manner as the OLE DB connection, just by selecting ODBC instead of OLE DB when

creating the connection string