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  General SQL Server Forums  New to SQL Server Administration  Importing data frm stored procedure results to xls

Author  Topic  gmahi Starting Member 9 Posts Posted - 2011-07-22 : 19:40:19 HI, I have been trying to export sql stored procedure results to excel file using bcp, It is going well but when i open the file it is opening in un organized way, is there any way to format the data while exporting to excel using bcp and one more problem is while am exporting the columns are not exporting to the file is there any way to get the column values . Thank you