This is a very easy task lately that doesn’t require you to do any coding and/or thinking. However, one might think there is an export function in SQL Server Management Studio but this is not the case.
First, start off by opening a new Excell worksheet (i’m using Office 2007).
So we select “data” on the ribbon menu and then “from SQL server”.
Enter the location and name of your SQLExpress server.
Select the table which you want to import in Excel.
Now you can just click “next” and “finish” and there you have it folks; the table is nicely imported in Excel. Hassle free!
As always; hope this helps someone out!