Vista - VB.NET: export query directly to Excel

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!

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.

On 2$B7n(B5$BF|(B, $B>e8a(B2$B;~(B51$BJ,(B, Mike J. <Mi...@xxxxxx> wrote:

Mike.

There are more posibilities (as well on this website)

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

Cor

"Mike J." <MikeJ@xxxxxx> wrote in message
news3EDBF73-CD66-4B4D-BD03-222290AF8A37@xxxxxx