QlikView Connectors to fetch data from Microsoft Sharepoint

[#1]

Hi,

We are planning to fetch data from the Excel files uploaded to MS Share point to maintain the security and changes in the Excel files.

Currently we are fetching data from Excel sheets, once we upload all the Excel files in Share point, how QlikView Apps will connect & fetch data from Share point.

What changes we need to do in the Scripts & connections to get the data from MS Share point?

[gajapathy74]

please refer this thread and link providedRe: Excel files from Share point

[#3]

Hi,

I have followed the thread.

While connecting to my Access file (.accdb), I am getting the following error message:

SQL##f - SqlState: S1000, ErrorCode: 4294963365, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] The database 'D:\QlikView\Data from Sharepoint\SSIT07.accdb' cannot be opened in exclusive mode because it contains links in cached mode.

SQL SELECT *

FROM "D:\QlikView\Data from Sharepoint\SSIT07.accdb".SSIT07

Thanks,

Ravindra

[gajapathy74]

Can you try to create ODBC for the access database and then try.