帮忙看一下代码, 是导出Excel到Datagrid,编译可以通过,单执行就会报异常,请高手指点
string strSel ="SELECT * FROM [CustomerName$]";
string strConnection=@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source= c:\suzhou; Extended Properties=Excel 8.0";
OleDbConnection con = new OleDbConnection(strConnection);
con.Open();
OleDbCommand myCommand = new OleDbCommand(strSel, con);
OleDbDataAdapter obj_adapter = new OleDbDataAdapter(myCommand);
DataSet obj_DataSet = new DataSet();
obj_adapter.Fill(obj_DataSet);
dataGrid1.DataSource=obj_DataSet.Tables[0].DefaultView;
当执行到 obj_adapter.Fill(obj_DataSet); 后,就开始报ole异常
我也不知道该怎么办