OleDBConnection连接字符串

Question

当我尝试此代码OleDBConnection.open()不工作，也没有抛出任何错误，只是打开windows窗体并说任何我看到的messageBox try1，但程序没有显示try2在我的连接字符串中的错误请帮助我已经尝试也excel 12.0，但它在参考Excel14.0中查找参考Excel14.0 (Microsoft Excel14.0对象库)和文件存在于c:\product.xlsx中

OleDbConnection conn_exel = new OleDbConnection(@"provider=Microsoft.Jet.OLEDB.12.0; Data Source=C:\product.xlsx; Extended Properties=""Excel 14.0;HDR=Yes;""");
        conn_exel.Open();
        MessageBox.Show("try2");
        OleDbCommand command_exel = new OleDbCommand(@"SELECT * FROM [Sayfa1$] WHERE id = 1",conn_exel);
        OleDbDataReader reader_exel =  command_exel.ExecuteReader();
        MessageBox.Show("try3");
        while (reader_exel.Read())
        {
            MessageBox.Show(reader_exel.GetString(1));
        }
        conn_exel.Close();

Answer 1

试着这样做

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES";

"HDR=Yes;“表示第一行包含列名，而不是数据。"HDR=No;“表示相反的意思。

reference

Answer 2

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + PathNam + ";
Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"

用于IMEX的http://www.nullskull.com/q/10173180/hello-would-you-explain-imex-option-when-import-excel.aspx