Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I am new to qlikview and I need some information on How to load MS access file in QLIKVIEW...
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
Make a ODBC connection string >> select ms access >> select data source and location of the MS-Access file
Then you get connection string
You can connect directly to the database.
You will need select the 32-bit connection option so your connection string shows as CONNECT32.
Open load script and load data from here
see the snap shot
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
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
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
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
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