Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  Excel alignment concern !! b

Author  Topic  turbo Starting Member 19 Posts Posted - 2010-08-03 : 08:21:16 i have a resultset with of a query where the field values are separated by '|', eg : sno100|john|abcd|description i have exported this resultset to excel sheet, The problem i am facin is that .I have a description column in my table which is of varchar(2000). If the description is short (say 10 char) the excel sheet is aligned properly. If it crosses more that a limited values it goes into multiline and this affects the alignment in the excel sheet. If u have any suggestion to this pls help me to do this.Thank you.