C#将dbf文件转为Datatable
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Text Documents (*.dbf)|*.dbf|All Files|*.*";
string filePath = null;
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
filePath = openFileDialog.FileName;
}
string fileName = System.IO.Path.GetFileName(filePath);
filePath = System.IO.Path.GetDirectoryName(filePath);
System.Data.Odbc.OdbcConnection conn = null;
string connectStr = "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277; Dbq=" + filePath;
conn = new System.Data.Odbc.OdbcConnection(connectStr);
string sql = "select * from " + fileName;
System.Data.Odbc.OdbcDataAdapter da = new System.Data.Odbc.OdbcDataAdapter(sql, conn);
conn.Open();
DataTable dt = new DataTable();
da.Fill(dt);