Exporting to excel

[John]

Hi

I have a winform db app with access backend db using strongly typed dataset.
Is there a way to run a query on a table and export the output into an excel
sheet with a specified name, overwriting the excel file if it already exists
at the destination. Is there a way to do all this by press of a button so
its easy for the end user?

Many Thanks

Regards

[cfps.Christian]

Do some research in using ODBC against an Excel table. This will
allow you to write SQL commands against the Excel table so you might
be able to do a delete on the spreadsheet and a bulk insert and be
done with it.

Your last option should be to use the Excel interop as it can be a
little unwieldy and a little too much precision.

[eBob.com]

"cfps.Christian" <ge*******@otc.eduwrote in message
news:1b**********************************@z28g2000 prd.googlegroups.com...

Do some research in using ODBC against an Excel table. This will
allow you to write SQL commands against the Excel table so you might
be able to do a delete on the spreadsheet and a bulk insert and be
done with it.

Your last option should be to use the Excel interop as it can be a
little unwieldy and a little too much precision.

I'm not the OP, but ... it never ceases to amaze me what useful information
I pick up here. I had not idea such a capability existed. THANKS!

BTW, in my experience the interop interface is not only unwieldy but it is
also difficult to find thorough documentation.

Bob

[cfps.Christian]

There's documentation!

The Excel interop isn't near as bad as the Word interop, its at least
slightly logical. The only warning I ever give when working with any
of the interops is to be certain that you manage your memory
correctly. They have a nasty habit of living until you're extremely
specific in shutting them down.

Since others might be interested:
www.connectionstrings.com to get the excel spreadsheet ODBC connection
string.
use $ before sheet name to query (took a co-worker the better part of
a week to figure that out)