string strConn = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + FileUpload1.PostedFile.FileName + ";Extended Properties=Excel 8.0";
System.Data.OleDb.OleDbDataAdapter excelDA = new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", strConn);
DataTable dt = new DataTable();
excelDA.Fill(dt);这个在本机没有问题,但是在服务器就有问题。
错误是:The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.
怎么解决啊,好烦啊
http://www.cnblogs.com/songliang/archive/2009/04/07/1430805.html
参照解决
insert into teacher_table(idcard,name,sex,) select 身份证号,姓名,性别 from opendatasource('microsoft.jet.oledb.4.0','data source=" + this.tfileup.PostedFile.FileName + ";Extended properties=Excel 5.0')...[sheet1$]说明: this.tfileup.PostedFile.FileName是excel路径
或者把你的excel文件放到服务器上相应路径看看