Create Access, Excel and .dbf output file from DataSet using C#

[Guest]

I have to create output file in a text, MS Access, MS Excel and .dbf format
from C# Win/ADO.NET application. Data are collected in DataSet and there is
no problem to make text file. However, I have to create a new output files
(tables with defined fields) in other 3 formats, and to fill them with data
from DataSet. I created Excel output with ComponentOne's trial Excel
component, but it is a temporary solution. Also I have unusual CP (1250 and
852), but it is another problem.

I am looking for a code-solution to create Access, Excel and .dbf output
files from DataSet using C#.
Could you please help me with some (pseudo-)code and/or link to similar
examples?

Thank you in advance, T

 

[Mohamoss]

Hi
Writing to an excel file or access database should not be a problem. You
will just need to create an oleDbAdapter with both type of files use its
update statement ( passing to it your dataset ) against the file where you
want you data to be saved . As for bdf you can simply save the dataset as
xml file (which is basically as text file) and you can convert that to bdf
. check that sample with source code on that link
http://www.codeproject.com/dotnet/pdfconverternet.asp
Mohamed Mahfouz
MEA Developer Support Center
ITworx on behalf of Microsoft EMEA GTSC