asp.net导入excel时 发生System.Data.OleDb.OleDbException: 未指定的错误

Question

  如题，各位大侠们有遇到过吧？？求解！
    public DataSet ExecleDs(string filenameurl, string table, string tablename)
    {
        string asvalue = "Sheet1$";
        if (tablename != "")
        {
            asvalue = tablename;
        }
        string strConn = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + filenameurl + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";
        OleDbConnection conn = new OleDbConnection(strConn);
        conn.Open();
        DataSet ds = new DataSet();
        OleDbDataAdapter odda = new OleDbDataAdapter("select * from [" + asvalue + "A1:AB50000]", conn);
        odda.Fill(ds, table);
        return ds;
    }
System.Data.OleDb.OleDbException: 未指定的错误 在 System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) 在 System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) 在 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) 在 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) 在 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) 在 System.Data.OleDb.OleDbConnection.Open() 在 Info_IndexTemplate.ExecleDs(String filenameurl, String table, String tablename) 位置

Answer 1

string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                        "Extended Properties=Excel 8.0;" + 
                        "data source=" + xlsPath;

Answer 2

操作权限
using(OleDbConnection conn = new OleDbConnection(strConn))
{
        conn.Open()
        OleDbDataAdapter odda = new OleDbDataAdapter("select * from [Sheet1$]", conn);
}
http://topic.csdn.net/u/20091228/11/99fbdb5b-08ef-4211-a9c7-2be803d654a5.html