使用C#.net将MDB文件中的表转换为CSV文件 [英] Convert table in MDB file to CSV file by using C#.net
本文介绍了使用C#.net将MDB文件中的表转换为CSV文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
请给我解决方案
给我确切的souttion
Please give me the solution
give me the exact souttion
推荐答案
Hi
希望这可以达到你想要的效果。
Hi
Hope this does what you want it to.
OleDb.OleDbConnection con = new OleDb.OleDbConnection();
string dbProvider = null;
string dbSource = null;
string dbTableName = null;
string sql1 = null;
int MaxRows = 0;
string outputCSV = "";
dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = ";
//Define these three variables
dbSource = "C:/Marks.mdb";
dbTableName = "Science_Marks";
int noOfColumns = 1;
////////////////////////////
con.ConnectionString = dbProvider + dbSource;
DataSet ds = new DataSet();
OleDb.OleDbDataAdapter da;
sql1 = "SELECT * FROM " + dbTableName;
con.Open();
da = new OleDb.OleDbDataAdapter(sql, con);
da.Fill(ds, dbTableName);
MaxRows = ds.Tables("FancyName").Rows.Count;
con.Close();
for (int i = 0; i < MaxRows; i++) {
for (int j = 0; j < noOfColumns; j++) {
outputCSV = outputCSV + ds.Tables("FancyName").Rows(i).Item(j)+",";
}
outputCSV = outputCSV + "\r\n";
}
//Save outputCSV to file, either by Save File Dialog or StreamWriter.
Jacques
Jacques
这篇关于使用C#.net将MDB文件中的表转换为CSV文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文