469,649 Members | 1,469 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,649 developers. It's quick & easy.

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

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

Thank you in advance, T
Nov 16 '05 #1
1 11254
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
Mohamed Mahfouz
MEA Developer Support Center
ITworx on behalf of Microsoft EMEA GTSC

Nov 16 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by David Elliott | last post: by
8 posts views Thread by DC Gringo | last post: by
6 posts views Thread by Steve Richter | last post: by
reply views Thread by Fendi Baba | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.