How to pull data from SharePoint? It's strange that you can import data from URL but not Sharepoin

Frank