"Failure creating file." Exception connecting to Excel on Sharepoint.

I need a connection string to connect to an Excel workbook that is stored ona corporate sharepoint site. I get a "Failure creating file" exception. Here is what I have been using:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=//myCompany.sharepoint.com/teams/RoboticProcessAutomation/coreteamarea/Shared%20Documents/Bot%20Tracker/Workspace%20Tracker.xlsx;Extended Properties='Excel 12.0 Xml;HDR=YES;'"

0 answers