Export SQL table to Excel in Sharepoint

Question

Reading from Sharepoint into SQL is a completed task.
Writing from an SQL table to an Excel file in Sharepoint is something I am stuck on.
I do have restrictions so using Reporting Services is likely not going to work.
Purchasing a an $800/yr license is something I can't sell.
Perhaps importing from SQL to PowerBI then out to Sharepoint is an option I have.

This person here is doing it but I do not know how.
https://learn.microsoft.com/en-us/answers/questions/300862/ssis-package-writing-to-excel-file-in-sharepoint.html

How do I use SSIS to write an Excel file on Sharepont?

thank you : - )

Answer 1

Hi @forresto ,

From the link you provided, it seems that he is using share folder to access the file such as \sharepoint\folder\file.xlsx.

I'm not familiar with SP, please have a check that you could also access the UNC path with SSIS and then you may load data to the excel on Sharepoint.

If this do not work, please consider downloading the excel file from SP first and then re-write and upload to SP.

This could also be done from SSIS.

https://www.techbrothersit.com/2016/07/how-to-download-file-from-sharepoint-by.html

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.