Load SQL Server Data into Excel


SQL Notes From The Underground

One of the regular tasks i need to do for our BA team is pull out some data from a database and let them see it in a readable format. The easiest way to do that is just call the query in SSMS. Right click on the results Grid, Copy with Header and Paste it into Excel.  Sadly since SQL Server 2008 (maybe r2) in SSMS 2012 / 2014 If you try this, when you paste into Excel the results are a mess and unreadable..

This post is alternate option should you need to get either a SQL Database Table or a Custom Query into Excel.

Open Excel -?> Data Ribbon -> Get External Data -> From Other Sources -> SQL Server

ExcelExternalDataSQLServer1

This opens the Data Connection Wizard, Connect to SQL instance

ExcelExternalDataSQLServer2

Select the database you want to query.  Note we cant start with a SQL Query so i just…

View original post 159 more words