<div>
It won't. &nbsp;You would have to export into character format which created a TAB delimited file and then import that into excel. &nbsp;Just hope your data contains no tabs.
</div>


It won't.  You would have to export into character format which created a TAB delimited file and then import that into excel.  Just hope your data contains no tabs.

<div>
<div class="content wysiwyg-content">
I have to cammand below which is crewating a file...just not actually in excel format. &nbsp;So I know I have my switches wrong for export to excel.<br />
<br />
Some help here?<br />
<br />
exec master.dbo.xp_cmdshell 'bcp &quot;select * from database.dbo.table1&quot; queryout C:\excelfile.xls -w -S SERVER\INSTANCE -T -E'
</div>
</div>


I have to cammand below which is crewating a file...just not actually in excel format.  So I know I have my switches wrong for export to excel.

Some help here?

exec master.dbo.xp_cmdshell 'bcp "select * from database.dbo.table1" queryout C:\excelfile.xls -w -S SERVER\INSTANCE -T -E'

SQL Server bcp command

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.