Extract data from MS Access File

[varunreddy]

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

[settu_periasamy]

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

[ramasaisaksoft]

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.