[=>在线<=]有谁遇到过这样的错误么
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' does not contain table 'GRW0511$'. The table either does not exist or the current user does not have permissions on that table. OLE DB error trace [Non-interface error: OLE DB provider does not contain the table: ProviderName='Microsoft.Jet.OLEDB.4.0', TableName='GRW0511$'].
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.Data.SqlClient.SqlException: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' does not contain table 'GRW0511$'. The table either does not exist or the current user does not have permissions on that table. OLE DB error trace [Non-interface error: OLE DB provider does not contain the table: ProviderName='Microsoft.Jet.OLEDB.4.0', TableName='GRW0511$'].
源错误:
行 186: sqls = "INSERT OPENDATASOURCE ('sqloledb','Data Source=161.92.143.8;User ID=gavin;Password=123456' ).VRAS.dbo.W0601 (Vendor,Purchasing,Trans,Material_Doc,Item,Posting_da,Quantity,Price,Amount,Curre,Reference,Document,Reference_Doc,Material,Plant,Week) SELECT * FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0','Data Source=p;User ID=Admin;Password=;Extended properties=Excel 5.0')...[GRW0511$]"
行 187: dim cmd as SqlCommand = new SqlCommand(sqls,Conn)
行 188: cmd.ExecuteNonQuery()
行 189: DataGrid1.visible = false
行 190: LABEL1.TEXT = "successful!"
PS: 1、EXCEL文件中肯定包含GRW0511这个sheet
2、我是以系统管理员登陆的,对EXCEL肯定有操作权限
我就是搞不明白,错误提示为什么会说找不到EXCEL中的那个sheet的 -_-! 大家谁遇到过这种情况么?该怎么去解决呢?