Export a Table to a Excel File

[faravani]

Hi i want export a table into database to a excel file i search s command in Sql Server That help me Export a Table in Excel File without create file manully please guide me

[Niladri_Biswas]

hi, the easiest way is Right Click on the result pane - >Save Result as.. You can save the result in excel.(I am sure for sql server 2005+ but unsure for 2000). Please check that if u r using 2000 version :)

Niladri Biswas

[Abhishek Sur]

Want to do a program on this ? Or just use Management console to export result?? If you are about to build a program, you might use this : Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^] Otherwise you can see what Niladri suggested in Management Console.:thumbsup:

Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.

---

My Latest Articles-->** Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

[dan sh]

Look into XP_CmdShell. That would help you achieving this thing. Make sure you enable that from Surface Area configuration.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

[Bassam Saoud]

BCP utility[^]

[Tripathi Swati]

you can use 1> DTS Export/Import utility for that please go thru http://support.microsoft.com/kb/319951[^] 2>exec master..xp_cmdshell but for that you need to enable from surface area configuration 3> BCP utility 4> you can use linked server for excel file to sql table.

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=\\servername\e$\inetpub\wwwroot\game\myexcelfile.xls;',
'SELECT * FROM [scores]') select * from LinkedServerName.DBname.tbl_Stats

5> SSIS package to transfer data from a table in a SQL Server 2005 database to a Microsoft Excel spreadsheet

Reasons are not Important but Results are Important. Swati Tripathi