September 22, 2017 at 2:29 am
Hi all,
Is it possible to import data from an Excel file located on a SharePoint folder through a linked server?
I have tried to open the Excel folder directly in Windows explorer, then use the direct link as data source in the linked server properties but that doesn't work.
I am aware of how to create a LS to Excel with the Microsoft driver, I am using the same settings but then only the online folder location.
Is it even technically possible?
Thanks for any help,
Henk
September 22, 2017 at 3:39 am
I dislike linked servers (because of its unstable behaviour by nature )
Why aren't you considering a (scheduled or evan ad-hoc launch) SSIS package ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 22, 2017 at 3:45 am
Unfortunately our platform currently only support the import by linked server, which I agree is not ideal but I'll have to try to make it work - if possible on SharePoint.
Cheers.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply