Does anyone know how to import a excel spreadsheet from a sharepoint site using Data Connector ?
Rather than a directory or drive path, I would like to use a sharepoint url as my OLEDB data source path. Would anyone have any quidance on this ?
Is this on prem SharePoint of Office365?
You could possibly map a drive to the file.
Thanks for responding Alex,
Sharepoint is off prem in the Cloud. Is there still away to do this ?
Regards
Hi WDRAIN1!
Only local or UNC paths are supported as source, so you can't use a URL there.