saving tables as .xls

  • Thread starter Thread starter Bernie Yaeger
  • Start date Start date
B

Bernie Yaeger

There must be a simple way of saving an sql table as a .xls file using ado
..net, but I can't find anything on it. Any help would be much appreciated.

Bernie Yaeger
 
Joe's solution is using an Excel Com object, which is good. There are some
other ways not needing that much code to do it.

Questions --

1. Will the Excel file already exist, or do you need to make it on the fly.
2. Will the version of Excel always be the same?
3. What version is Excel.
4. What about export to csv files, then incorporating to excel?

Bob J.
 
Back
Top