By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,231 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,231 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply

P: n/a
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.