copy table data to excel through stored procedure.

you can use SSIS to make your life easy

http://plexussql.blogspot.com/2010/04/emailing-work-log-notification-to.html

Or you can use a SP to makse your life hard like

https://www.excel-sql-server.com/sql-server-export-to-excel-using-bcp-sqlcmd-csv.htm

https://www.sqlservercentral.com/Forums/Topic1715295-391-1.aspx

Befor you pick a solution makse sure that you are not blocked by the security/DBA/Devops team

Good luck

0

Thank you Packiaraj Santhiyagu,

But I need each id related data should separately stored in an excel sheet at a time through stored procedures.

+1

Hi,

I hope below link will help you

https://stackoverflow.com/questions/36987636/cannot-create-an-instance-of-ole-db-provider-microsoft-jet-oledb-4-0-for-linked

+1