Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to load MS access file in QLIKVIEW

hi,

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

9 Replies
ashfaq_haseeb
Champion III
Champion III

Hi

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

its_anandrjs

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

Then you get connection string

Colin-Albert

You can connect directly to the database.

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

its_anandrjs

Open load script and load data from here

see the snap shot

msaccess.png

its_anandrjs

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

Not applicable
Author

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

khadeer
Specialist
Specialist

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

Not applicable
Author

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

maxgro
MVP
MVP

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