VB.NET: export query directly to Excel

[Mike J.]

I have searched for methods to export a SQL query directly to an Excel
document, but all I can find is exporting from a GridView to Excel (which I
do have working). Is there a way to export the resulting data of a SQL query
and send it to an Excel document without binding that to a GridView first?

We are using Visual Basic .NET 2005 and Oracle 10g databases. I have most
of the project's work in the asp.net side including the SqlDataSource with a
small amount of code-behind stuff in the .vb files.

Thank you!

 

[Jerry]

There are several ways:
- Excel Automation (needs to have Excel installed)
- Use OLEDB
- Read/Write directly to native format (there are commercial lib and
open source lib, such as http://code.google.com/p/excellibrary/ )

J.

 

[Cor Ligthert[MVP]]

Mike.

There are more posibilities (as well on this website)

http://www.vb-tips.com/DataGridViewExport.aspx

Cor