Export table to Excel in SQL Server 2008 [Resolved]

Posted by Riyazhaider under Sql Server on 4/19/2014 | Points: 10 | Views : 1610 | Status : [Member] | Replies : 3
I am using SQL Server 2005 in my web application, and i am using sp_makewebtaks to export table to excel format.
Now i am migration to SQL Server 2008 where sp_makewebtask is not available
how to perform same task in SQL Server 2008 with C#/VB.




Responses

Posted by: A2H on: 4/19/2014 [Member] [MVP] Silver | Points: 50

Up
0
Down

Resolved
You can take a look at the below link to export data from SQL Server to Excel from Asp.Net

http://dotnetmentors.com/c-sharp/how-to-export-sql-data-to-excel-using-microsoft-office-interop.aspx

Alternatively if your requirement is to just export the data from sql server to Excel, then you can try the below options

SQL Server

You can use the SQL Sever Export Import Wizard to retreive and save data
http://www.mssqltips.com/sqlservertutorial/202/simple-way-to-export-data-from-sql-server/

Another suggestion is to use SSIS to import data from SQL Server to Excel
http://technet.microsoft.com/en-us/sqlserver/ff686858.aspx


Thanks,
A2H
My Blog

Riyazhaider, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Riyazhaider on: 4/21/2014 [Member] Starter | Points: 25

Up
0
Down
Thank's dude.

Riyazhaider, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: A2H on: 4/21/2014 [Member] [MVP] Silver | Points: 25

Up
0
Down
Glad to be of help.

Thanks,
A2H
My Blog

Riyazhaider, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response