How can i export datatable to excel

[Leena]

Hi,
I want to know that how can i export the datatable to ms excel?
Is there any quice way to do this? or delimited the file?
Where is the appropriate Microsoft monitored group to ask about
writing reports in SQL Reporting services or SQL Server
Business Intelligence Development Studio or whatever it's called?

[Matellis]

It's going to be slow compared to native VBA code. There are a few ways to
do thiis...the best of which is to query the DataBase
directly from Excel.
If you check out www.aspnetPRO.com (October 2003) they discuss Exporting to
Excel in depth, albiet primarily from the perspective of ASP.NET.

[Leena]

I should have made this clearer. I mean a datatable in VB.net.
dim mydt as new datatable
myodbcdataadapter.fill(mydt)
do some processing then export to excel.

[Matellis]

If we want to use the System.Web.UI.WebControls in the console or windows
form VB.NET application. We need to add a reference to System.Web assembly.
To reference this assembly in VB.NET 2008, we open the Solution Explorer
Window, right click our project and choose Add Reference option. Then, the
Add Reference dialog pops up. In the .NET tab, we find and select the
System.Web, and click the OK button. Afterwards, we can use the
System.Web.UI.WebControls.DataGrid.