Raw Excel Export?

  • Thread starter Thread starter localhost
  • Start date Start date
L

localhost

I have a DataSet with 3 named DataTables. What is the fastest way to
create a new workbook and spit each DataTable to a new worksheet?

Thanks.
 
Thanks, but that is not exactly what I am looking for.

I am not doing an ASP.NET project. I am working inside a console
application. I have some code that pulls data from MSSQL into a
DataSet. Now I need to blast that data into an Excel file. I have
used the Jet driver in the past to read from Excel, but not to write.

Help.


Thanks.
 
Hi localhost,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to export data in three tables
of the DataSet to Excel worksheet. If there is any misunderstanding, please
feel free to let me know.

I think we can do this by copying all data to a new DataSet and update that
to the database. Since Excel is a little different from other databases,
here are some KB articles about how to achieve this.

http://support.microsoft.com/?id=316934
http://support.microsoft.com/default.aspx?kbid=306023

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Back
Top