Excel文件导入页面中数据信息无法导入!请高手帮忙!
polyn 2003-09-24 09:44:29 源程序:
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Inetpub\\wwwroot\\WebReport\\aa.xls;Extended Properties=Excel 8.0;");
OleDbCommand myCommand = new OleDbCommand("SELECT * FROM [Sheet1$]", myConnection);
OleDbDataAdapter OleAdapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]",myConnection);
DataSet myDataSet = new DataSet();
OleAdapter.Fill(myDataSet);
DataGrid1.DataSource = myDataSet.Tables[0];
DataGrid1.DataBind();