sp_Excel

Are you looking for a way to create Microsoft Excel documents using only SQL Server? Are you having trouble using SQL Server's Data Transformation Service (DTS) to accomplish this? Here is your answer. You can use sp_Excel to create Excel documents on the fly using a stored procedure. With sp_Excel you have all the basic functionality you need to export data to Microsoft Excel from within the stored procedure plus a little more.

sp_Excel is open source. Simply download sp_Excel and compile it either as a system stored procedure on your master database or as a user-defined stored procedure on your own database and you are ready to go.

sp_Excel works with Microsoft Excel's Component Object Model from within T-SQL by using the power of SQL Server's OLE Automation Stored Procedures. Therefore all the objects, properties and methods exposed in the Excel Object Model are available from within T-SQL.

After you download sp_Excel feel free to modify it as you wish since it is open source code. I had a need for this technology, so I created this procedure to help me out and I have now made it available to you. Have fun and don't break anything!

$4.95 Click here to receive sp_Excel!