ODBC Qlik Cloud connection via Microsoft Excel driver to the file located on SharePoint

[McSim]

I need to retrieve data from .xlsb files located on SharePoint and also to read all existing sheets names from normal .xlsx files located there. I assume in both cases ODBC connection via  Microsoft Excel driver could work for me, but not sure how to set up the connection.

I tried to create connection string based on SharePoint link, based on links to local files, also tried to connect to attached files - no results (different error messages with lack of info what is wrong).

Could you help me please with typical connection string and other parameters  to get connected to xlsx or xlsb files?

(Qlik Sense SaaS, Microsoft Excel Driver installed on the server)

[Chetan_MN · Accepted solution]

Hi @McSim Did you refer to below documentation?

https://help.qlik.com/en-US/cloud-services/Subsystems/Web_Storage_Provider_Connectors_help/Content/C...

[JustinDallas]

Like @Chetan_MN said, you have to use the Web Connectors to connect to Sharepoint.

You're also going to want to look at this because connecting to Sharepoint can be more involved than you would expect at first:

https://community.qlik.com/t5/Official-Support-Articles/How-to-load-a-file-from-SharePoint-365-using...