SQLServerCentral.com / SQL Server 2005 / T-SQL (SS2K5) / SQL 2005 into designed Excel via Stored Procedure. / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 31 Mar 2015 14:49:30 GMT20RE: SQL 2005 into designed Excel via Stored Procedure.http://www.sqlservercentral.com/Forums/Topic1481208-338-1.aspxBecause I'm old and it still works, I use vb6 to create excel (from SQL stored procedures) and format within the vb code.I've been sending various reports to people in my agency this way for years and they love it.We have a dedicated machine that runs the vb.exe file when scheduled.Fri, 09 Aug 2013 16:04:06 GMTtim.hansenRE: SQL 2005 into designed Excel via Stored Procedure.http://www.sqlservercentral.com/Forums/Topic1481208-338-1.aspx[quote][b]Koen Verbeeck (8/6/2013)[/b][hr][quote][b]BOR15K (8/6/2013)[/b][hr]I guess I need to look for another solution as customer's sites do not have SSRS installed.Any other advise, please?Kind Regards[/quote]The only tool in the SQL Server stack that can format Excel files is SSRS.All the others (SSIS for example) just dump the raw data into the Excel file. You could try to work with named ranges though as destinations in SSIS, but SSIS is not included in SQL Server express.Macro's are always another alternative. You take an excel file with the layout already present and you fetch the data using a macro.[/quote]I see there is also an option to export into html style file and just to change its extension. But then my issue is an image. Although I have converted it into base64 and can see it in html, in the excel it ignores it and just shows the x instead.&lt;html xmlns:v="urn:schemas-microsoft-com:vml"xmlns:o="urn:schemas-microsoft-com:office:office"xmlns:x="urn:schemas-microsoft-com:office:excel"xmlns="http://www.w3.org/TR/REC-html40"&gt;Thanks a lot!Tue, 06 Aug 2013 14:15:09 GMTBOR15KRE: SQL 2005 into designed Excel via Stored Procedure.http://www.sqlservercentral.com/Forums/Topic1481208-338-1.aspx[quote][b]SGT_squeequal (8/6/2013)[/b][hr]HI I have just implimeted something a little similar in excell however, instead of exporting from SQL i import from excel.I created a button on spreadhseet then create some VBA to open a connection and then populate a worksheet, works wonders [url=http://social.msdn.microsoft.com/Forums/en-US/f599f280-b786-43f4-9357-77f19a107c3f/vba-in-excel-connect-to-sql-server][/url]:-D[/quote]Thanks a lot - it looks cool indeed! But my problem is that the Excel file will be sent to clients, which won't be able to access customer's SQL server.Thanks again!Tue, 06 Aug 2013 14:11:19 GMTBOR15KRE: SQL 2005 into designed Excel via Stored Procedure.http://www.sqlservercentral.com/Forums/Topic1481208-338-1.aspxHI I have just implimeted something a little similar in excell however, instead of exporting from SQL i import from excel.I created a button on spreadhseet then create some VBA to open a connection and then populate a worksheet, works wonders [url=http://social.msdn.microsoft.com/Forums/en-US/f599f280-b786-43f4-9357-77f19a107c3f/vba-in-excel-connect-to-sql-server][/url]:-DTue, 06 Aug 2013 13:56:22 GMTSGT_squeequalRE: SQL 2005 into designed Excel via Stored Procedure.http://www.sqlservercentral.com/Forums/Topic1481208-338-1.aspx[quote][b]BOR15K (8/6/2013)[/b][hr]I guess I need to look for another solution as customer's sites do not have SSRS installed.Any other advise, please?Kind Regards[/quote]The only tool in the SQL Server stack that can format Excel files is SSRS.All the others (SSIS for example) just dump the raw data into the Excel file. You could try to work with named ranges though as destinations in SSIS, but SSIS is not included in SQL Server express.Macro's are always another alternative. You take an excel file with the layout already present and you fetch the data using a macro.Tue, 06 Aug 2013 13:21:56 GMTKoen VerbeeckRE: SQL 2005 into designed Excel via Stored Procedure.http://www.sqlservercentral.com/Forums/Topic1481208-338-1.aspxI guess I need to look for another solution as customer's sites do not have SSRS installed.Any other advise, please?Kind RegardsTue, 06 Aug 2013 11:34:26 GMTBOR15KRE: SQL 2005 into designed Excel via Stored Procedure.http://www.sqlservercentral.com/Forums/Topic1481208-338-1.aspxThank you for your help.Kind RegardsTue, 06 Aug 2013 04:40:46 GMTBOR15KRE: SQL 2005 into designed Excel via Stored Procedure.http://www.sqlservercentral.com/Forums/Topic1481208-338-1.aspxImages in SSRS:[url=http://technet.microsoft.com/en-us/library/dd239394.aspx]Images (Report Builder and SSRS)[/url]Some tutorials:[url=http://technet.microsoft.com/en-us/library/bb522859.aspx]Reporting Services Tutorials (SSRS)[/url]Reporing Services is supported to some extent in SQL Server 2005 Express with Advanced Services:[url=http://technet.microsoft.com/en-us/library/ms143761(v=sql.90).aspx]Features Supported by the Editions of SQL Server 2005[/url]Tue, 06 Aug 2013 04:36:01 GMTKoen VerbeeckRE: SQL 2005 into designed Excel via Stored Procedure.http://www.sqlservercentral.com/Forums/Topic1481208-338-1.aspxI understand,Is there any particular website you would suggest to have a look how to create SSRS with images, please?Also I have a concern that some of the clients may run only SQL 2005 Express version. Will the SSRS work for them as well?Kind RegardsTue, 06 Aug 2013 03:55:20 GMTBOR15KRE: SQL 2005 into designed Excel via Stored Procedure.http://www.sqlservercentral.com/Forums/Topic1481208-338-1.aspxSure. You can schedule SSRS reports. And if a user needs the Excel report, he can always run the report itself.Tue, 06 Aug 2013 03:41:31 GMTKoen VerbeeckRE: SQL 2005 into designed Excel via Stored Procedure.http://www.sqlservercentral.com/Forums/Topic1481208-338-1.aspxThank you for the reply.Do you think it would be a good approach for automated processes, which might be invoked by end-userfrom an application?Kind RegardsTue, 06 Aug 2013 03:33:40 GMTBOR15KRE: SQL 2005 into designed Excel via Stored Procedure.http://www.sqlservercentral.com/Forums/Topic1481208-338-1.aspxI would create a report in SSRS and then export the report to Excel.Tue, 06 Aug 2013 03:18:37 GMTKoen VerbeeckSQL 2005 into designed Excel via Stored Procedure.http://www.sqlservercentral.com/Forums/Topic1481208-338-1.aspxHi All,I need to export data from SQL 2005 into Excel. I know I can use bcp or OPENSOURCE, but the requirement is that I needto customise my excel: with titles of different sizes, company's logo, making various results bold and so.I assume the best way to do so would be by creating an html or even xml file, but cannot find a proper example, so my questions are:- what is the best way to create such an Excel file?- can some one point me to a website I can have a look, or even post some basic example here, please?Any suggestion will be much appreciated!Thanks!Tue, 06 Aug 2013 03:07:09 GMTBOR15K