Buy Questpond's video subscriptions on
huge discount
.
Online: 1092
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Forums
>
Sql Server
>
Loading ...
Export table to Excel in SQL Server 2008 [Resolved]
Posted by
Riyazhaider
under
Sql Server
on 4/19/2014 |
Points: 10
| Views : 2396 | Status :
[Member]
| Replies : 3
Write New Post
|
Search Forums
|
Resolved Posts
|
Un Answered Posts
|
Forums Home
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.
[Resolved]
Reply
|
Reply with Attachment
Alert Moderator
Responses
Posted by:
A2H
on: 4/19/2014
[Member]
[MVP]
Silver
|
Points: 50
0
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
0
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
0
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
Latest Posts
Climax Delay Condoms for Long Lasting Pleasure
(0)
Iterating over columns of dataframe and print as rows in Python Django
(0)
Where can I found sample MVC projects to learn and improve skills
(1)
Extract a value from HTML string
(0)
Get only year part from date string in SQL server
(0)
Get only year part from date string in SQL server
(0)
Get only year part from date string in SQL server
(0)
Get only year part from date string in SQL server
(0)
More ...