使用C＃.net将MDB文件中的表转换为CSV文件 [英] Convert table in MDB file to CSV file by using C#.net

问题描述

请给我解决方案



给我确切的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屋！