topic Re: How to load MS access file in QLIKVIEW in QlikView

How to load MS access file in QLIKVIEW

Mon, 21 Apr 2014 10:02:48 GMT

hi,

I am new to qlikview and I need some information on How to load MS access file in QLIKVIEW...

Re: How to load MS access file in QLIKVIEW

ashfaq_haseeb — Mon, 21 Apr 2014 10:07:22 GMT

Go to script editor and select OLEDB drivers and select microsoft jet oledb 4.0 drivers.

If you don't find then I would suggest you to download the Acess database engine from the below link.

http://www.microsoft.com/en-us/download/details.aspx?id=13255

Hope it helped.

Regards

ASHFAQ

Re: How to load MS access file in QLIKVIEW

its_anandrjs — Mon, 21 Apr 2014 10:08:43 GMT

Make a ODBC connection string >> select ms access >> select data source and location of the MS-Access file

Then you get connection string

Re: How to load MS access file in QLIKVIEW

Colin-Albert — Mon, 21 Apr 2014 10:09:14 GMT

You can connect directly to the database.

You will need select the 32-bit connection option so your connection string shows as CONNECT32.

Re: How to load MS access file in QLIKVIEW

its_anandrjs — Mon, 21 Apr 2014 10:11:54 GMT

Open load script and load data from here

see the snap shot

Re: How to load MS access file in QLIKVIEW

its_anandrjs — Mon, 21 Apr 2014 10:13:25 GMT

After connect to the ms-access you get connection string some thing like this

ODBC CONNECT TO [MS Access Database;DBQ=D:\t1.accdb]; //DB Connection String

Re: How to load MS access file in QLIKVIEW

Mon, 21 Apr 2014 10:22:19 GMT

Hello Akash,

Make a ODBC connection string

select ms access ---> select data source and location of the MS-Access file

If any problem persist then check force 32-bit check box

Then u ll make the connection string...

Regards,

Hassaan

Re: How to load MS access file in QLIKVIEW

khadeer — Mon, 21 Apr 2014 11:29:15 GMT

Hi,

For any database you have to generate connection string( Interface between Database and QV). To establish the connection you have to generate DSN. In case of MS acces files you can fetch directly. For DSN creation..

Go to Control Panel--> Administrative Tools--> ODBC----> Select your DataBase--->

Then after you have to give some credentials like IP Address, Username And Password...

It will Establish connection string .... U can fetch from Select option from Edit Script.

You can establish MS-Access Database connection string in the same manner.

Regards,

Khadeer

Re: How to load MS access file in QLIKVIEW

Mon, 21 Apr 2014 12:22:52 GMT

Hi Akash

The best way to connect to MS Access and other RDBMS data base is using the OLE DB

When You open the Qlikview or New QlikView

Press Ctrl + E or Click on File | Edit Script

Select OLEDB from Dropdown under the data base section

Click on Connect

Select The Driver for MS Access under the provider Tab

Click next to select the path where the Access database was stored.

Test the Connection and click on OK

Re: How to load MS access file in QLIKVIEW

maxgro — Mon, 21 Apr 2014 13:07:45 GMT

see attachment for an example using oledb with access

(adapt the connection path to your)

or the below video if you want to use odbc to load access data

Video: Load Data from ODBC