c# excel导入access和access 导出到excel 问题

Question

excel导入access
excel的表a：
a b
b c
access表b：
type number value1 values2先要得到结果：
type number value1 values2
1     1     a        b
1     2     b        c
access 导出到excel 
access表b：
type number value1 values2
1     1     a        b
1     2     b        c
结果：
excel的表a：
a b
b c
求提供高效代码，导出的也是

Answer 1

access导出为excel参考
http://topic.csdn.net/u/20091027/20/39b0adfc-e9f4-4ed4-9e2c-4105ac1346e8.htmlexcel导入到access参考
http://topic.csdn.net/u/20091109/20/18a0f08d-2b34-465b-8ce4-f66eef74207f.html

Answer 2

private DataTable XlsToDataTable(String strpath) 
    { 
        string strConn; 
        strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strpath + ";" + 
        "Extended Properties=Excel 8.0;"; 
        OleDbConnection conn = new OleDbConnection(strConn); 
        OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn); 
        DataTable dt = new DataTable(); 
        myCommand.Fill(dt); 
       return dt; 
    } 或
private void button1_Click(object sender, EventArgs e) 
        { 
            string str="";
            oleDbConnExcel = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Extended properties=Excel 5.0;Data Source=" + Application.StartupPath.Trim() +"\\a.xls"); 
            oleDbConnExcel.Open(); 
            strGetDataFromExcel = "SELECT * FROM [Sheet1$]"; 
            oleDbCmdExcel = new OleDbCommand(strGetDataFromExcel, oleDbConnExcel); 
            oleDbDataReaderExcel = oleDbCmdExcel.ExecuteReader(); 
            if (oleDbDataReaderExcel.HasRows == true) 
            { 
                oleDbConnAccess.Open(); 
                for (; ; ) 
                { 
                    if (oleDbDataReaderExcel.Read()) 
                    { 
                        str= ""; 
                        oleDbCmdAccess = new OleDbCommand(str, oleDbConnAccess); 
                        oleDbCmdAccess.ExecuteNonQuery(); 
                        oleDbCmdAccess.Dispose(); 
                    } 
                    else 
                        break; 
                } 
                oleDbConnAccess.Close(); 
            } 
            oleDbDataReaderExcel.Close(); 
            oleDbCmdExcel.Dispose(); 
            oleDbConnExcel.Close(); 
        } 
或直接代码excel模板，遍历数据集，导入excel