Create XLS file from Query? (VB, OLEDB, ADO.NET 2.0)

[Confused Newbie]

I need to create new Excel 2003 XLS files containing a single worksheet that
has the results of a database query (a combination of text, integer, and
date columns). Can someone please point me to an example of how to do this
in a VB2005/ADO.NET 2.0 Winforms app, *WITHOUT* using Interop (Office will
*not* be installed on the machine generating the file). Thanks!

 

[Jim Hughes]

Visual Studio Tools for Office Developer may meet your needs.

http://msdn.microsoft.com/office/understanding/vsto/

The developer machine will need Office, but the deployment machine may not
depending on the solution used.

http://msdn.microsoft.com/office/un...05_ta/html/officevstobenefitsregistration.asp

has a specific example of a server based solution for creating documents.

 

[Paul Clement]

¤ I need to create new Excel 2003 XLS files containing a single worksheet that
¤ has the results of a database query (a combination of text, integer, and
¤ date columns). Can someone please point me to an example of how to do this
¤ in a VB2005/ADO.NET 2.0 Winforms app, *WITHOUT* using Interop (Office will
¤ *not* be installed on the machine generating the file). Thanks!
¤

What is the data source (SQL Server? Access?) of your database query?


Paul
~~~~
Microsoft MVP (Visual Basic)