SRS 2005 Export to EXCEL
Is there anyway to turn off Wrap Text formating on report rows/colimns as it is exported to EXCEL from Reporting Services 2005

Answer Question   |  January 11, 2011  1:20 PM
SQL Export to Excel, SQL Server 2005, SQL Server Reporting Services, SSRS 2005

Excel as a front end to sql, data integrity
how do I put a value in a sql field that will not be counted in a excel pivot table? I am using excel as a front-end to sql. In particular, I am using pivot tables to slice and dice sql tables. The field I am interested in has either a text value or a [...]

Answer Question   |  July 27, 2010  6:00 PM
Excel Database, SQL 2005, SQL Export to Excel, SQL Server, SQL to Excel Database Conversion

SQL Export to Excel file column?
I need to create a SSIS Package in which the data is export to Excel file the problem is the date and time column in sql there is one column and i need to separate it into two column can any body help e i thid? thank in advance

Answer Question   |  April 4, 2009  1:13 AM
Microsoft Excel, SQL Export to Excel, SSIS, SSIS 2005, SSIS Package 2005