none
Need to import Excel sheet data (From SharePoint Online document Library) into MS Access.

    Question

  • We have migrated our Data/Sites from SharePoint On-Premise to SharePoint Online and faced many challenges. One of the issue is we are trying to Import Excel sheet data named ABC.xlsx (which is resides there on SharePoint online document library) into the MS Access (Installed on Local Machine). We are able to browse ABC.xlsx from browser as well as from MS Access too, but we cannot Open/Import excel sheet from source. Whenever we try to Import it from source (SharePoint Online Library) got error says "The file '//domain.sharepoint.com/sites/SiteName/Shared Documents/ABC.xlsx' does not exist". Same process we follow for SharePoint On-premise Excel file, It works but not with SharePoint Online. We have tried to Import the same from Access app (got it from SharePoint Add an App from site content) but same result as previous one.

    Need you help team.          

    Monday, July 11, 2016 2:59 PM

Answers

  • We have managed to re-link those excels using following address

    \\Domain.sharepoint.com@SSL\DavWWWRoot\Manage_Path\SiteCollection_Name

     
    Tuesday, January 3, 2017 7:07 AM