Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL 2005 into designed Excel via Stored Procedure. Expand / Collapse
Author
Message
Posted Tuesday, August 6, 2013 3:07 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 2:41 PM
Points: 123, Visits: 301
Hi 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 need
to 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!
Post #1481208
Posted Tuesday, August 6, 2013 3:18 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:49 AM
Points: 13,570, Visits: 11,379
I would create a report in SSRS and then export the report to Excel.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1481211
Posted Tuesday, August 6, 2013 3:33 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 2:41 PM
Points: 123, Visits: 301
Thank you for the reply.

Do you think it would be a good approach for automated processes, which might be invoked by end-user
from an application?

Kind Regards
Post #1481216
Posted Tuesday, August 6, 2013 3:41 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:49 AM
Points: 13,570, Visits: 11,379
Sure. You can schedule SSRS reports. And if a user needs the Excel report, he can always run the report itself.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1481220
Posted Tuesday, August 6, 2013 3:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 2:41 PM
Points: 123, Visits: 301
I 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 Regards
Post #1481221
Posted Tuesday, August 6, 2013 4:36 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:49 AM
Points: 13,570, Visits: 11,379
Images in SSRS:
Images (Report Builder and SSRS)

Some tutorials:
Reporting Services Tutorials (SSRS)

Reporing Services is supported to some extent in SQL Server 2005 Express with Advanced Services:
Features Supported by the Editions of SQL Server 2005




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1481227
Posted Tuesday, August 6, 2013 4:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 2:41 PM
Points: 123, Visits: 301
Thank you for your help.

Kind Regards
Post #1481229
Posted Tuesday, August 6, 2013 11:34 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 2:41 PM
Points: 123, Visits: 301
I guess I need to look for another solution as customer's sites do not have SSRS installed.
Any other advise, please?

Kind Regards
Post #1481469
Posted Tuesday, August 6, 2013 1:21 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:49 AM
Points: 13,570, Visits: 11,379
BOR15K (8/6/2013)
I guess I need to look for another solution as customer's sites do not have SSRS installed.
Any other advise, please?

Kind Regards


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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1481516
Posted Tuesday, August 6, 2013 1:56 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, November 22, 2014 12:05 PM
Points: 271, Visits: 1,021
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]


*************************************************************

The first is always the hardest
Post #1481539
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse