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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

space used in memory for a table and its indexes 8
Converted xlsx file to xls. New xls file isn't right, try to correct, fails compat checker 0
What are the steps to fix damaged MDF files in SQL Server? 0
using a dataset/datatable as input for a crystal report 7
nulled out - defaults instead? 3
ma access query to assign pk 2
Loading Data Tables in C# 1
non typed dataset and codegen:nullValue="_empty" 2

Back
Top