Export a query result to somewhere.

Suppose I want to query a table, how can I convert it into a word file table.

I want submit a report to my boss.

I am using SQL Server 2005 Management Studio Express.

Thanks

May 1st, 2008 10:42pm

First you copy and paste it into Excel.

Then copy and paste it into Word.

Free Windows Admin Tool Kit Click here and download it now
May 1st, 2008 10:45pm

SQL Server express does not include reporting services or integration services. You can download sql server express advances which includes a scaled down version of sql server reporting services. Sql server management studio express does not provide any type of native support for report generation. The link below provides the download for sql server express advanced that does provide limited reporting solution, which would be your best option for an integrated solution.

http://www.microsoft.com/downloads/details.aspx?familyid=4C6BA9FD-319A-4887-BC75-3B02B5E48A40&displaylang=en

Hope that this helps

May 1st, 2008 11:51pm

You can check the below thread for the same
http://forums.microsoft.com/forums/ShowPost.aspx?PostID=3240524&SiteID=1

You can also try the below utility to export the queried result to excel sheet. Click here to download SqlDbx Personal
Free Windows Admin Tool Kit Click here and download it now
May 2nd, 2008 12:32pm

If you are using Microsoft OFFICE 2013, we can achieve using Data Pull method rather than Push method.

Open MS Word, Go to "Insert" and select "Insert Excel Sheet"

Select the OLE excel object.

Go to "DATA" tab and establish an SQL Server connection.

You can specify the SQL query to retrive the result set.

January 13th, 2014 6:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics