<div>
Install ssmsBoost toolkit, its freeware; You will be able to do things like exporting into excel and more
</div>


Install ssmsBoost toolkit, its freeware; You will be able to do things like exporting into excel and more

elwayisgod

<div>
Thanks but can't do that as it's a work laptop and we are blocked.<br />
<br />
I just found 'Save Results As' and that goes to .csv so that will work....
</div>


Thanks but can't do that as it's a work laptop and we are blocked.

I just found 'Save Results As' and that goes to .csv so that will work....

<div>
Also, you can just right click into the top left cell (to left of column headers) and choose either copy or copy with headers then paste into Excel.<br />
<br />
Kelvin
</div>


Also, you can just right click into the top left cell (to left of column headers) and choose either copy or copy with headers then paste into Excel.

Kelvin

<div>
<div class="content wysiwyg-content">
SQL Server Management Studio - When I select Query-&gt;Results To-&gt;Results To File &nbsp;it doesnt generate a .rpt file. &nbsp;Nothing happens so I can get a .rpt file to Export into Excel. &nbsp; <br />
<br />
I have results too.... I'm stumped.
</div>
</div>


SQL Server Management Studio - When I select Query->Results To->Results To File  it doesnt generate a .rpt file.  Nothing happens so I can get a .rpt file to Export into Excel.   

I have results too.... I'm stumped.

SQL Server Management Studio - Export results to Excel

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.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.