topic Re: Extract data from MS Access File in QlikView

Extract data from MS Access File

varunreddy — Thu, 19 Nov 2015 01:47:12 GMT

Hi Guys,

I have data in MS Access file. I need to extract into QlikView and develop a dashboard.

Can anyone help me understand how can I connect to QlikView and extract data from MS Access File?

Also can anyone help me in understanding, ho can I connect to ODBC or OLEDB?

Thanks in advance

Cheers,

Varun Reddy. K

Re: Extract data from MS Access File

settu_periasamy — Thu, 19 Nov 2015 01:52:40 GMT

Hi Varun,

See the below discussion. In the end maxgro given the sample file to connect the MS ACCESS..

How to load MS access file in QLIKVIEW

Re: Extract data from MS Access File

ramasaisaksoft — Thu, 19 Nov 2015 07:14:10 GMT

Hi Varun,

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.