C#窗体excel与dbf的导入导出

**

网上能搜到的比较零碎，整理帖

**

导入比较简单代码如下

EXCEL
private void button2_Click(object sender, EventArgs e)
{
string fileName = “”;
fileName = this.textBox1.Text;
if (this.textBox1.Text != “”)
{
try
{
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + fileName + " ;Extended Properties=Excel 8.0";
System.Data.OleDb.OleDbConnection myConn = new System.Data.OleDb.OleDbConnection(strCon);
string strCom = " SELECT * FROM [Sheet1$] ";
System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strCom, myConn);
DataTable dt = new DataTable();
myCommand.Fill(dt);
this.dataGridView1.DataSource = dt;
}
catch
{
MessageBox.Show(“请选择需要导入的文件”);
}
}
else
{
MessageBox.Show(“请选择Excel文件”);
}
}
DBF
private void button3_Click(object sender, EventArgs e)
{
try
{
string fileName = textBox1.Text;
if (this.textBox1.Text != “”)
{
FileInfo fi = new FileInfo(fileName);
string mulu = fi.DirectoryName;
string filename = fi.Name;

            OleDbConnection conn = new OleDbConnection();
            string table = filePath;

            string connStr = @"Provider=VFPOLEDB.1;Data Source=" + mulu + ";Collating Sequence=MACHINE";

            conn.ConnectionString = connStr;
            conn.Open();

            string sql = @"select * from " + filename;
            OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);
            DataTable dt = new DataTable();
            da.Fill(dt);
            this.dataGridVie