Hello
I'm looking for a way to export data in a SQL table to excel and have it saved locally or sent by email.
Any idea how to do this?
Thanks

Hi there,

You have a number of options including DTS / SSIS (SQL Server Integration Services) for exporting the data from the server (as a nightly process for exampe) or by exporting to HTML that looks like an Excel file from an ASP.NET page if you need it as part of the user's interaction. You can also use third party components to generate true Excel files. It all depends on what you're trying to achieve and how.

But since this isn't related to my book, you're better off posting this in a general SQL or ASP.NET category here at p2p.wrox.com. This way you'll attract more viewers. If you decide to post there, be sure to provide more information about what you're trying to accomplish.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Imar, thanks for your answer.
Alex