关于连接excel

Question

        string file_path = Server.MapPath(@".\file\ado.xls");
        string m_con = @"Provider=Microsoft.Jet.OLEDB.4.0;Source=" + file_path + ";Extended Propertice=Excel 8.0;";
        OleDbConnection con = new OleDbConnection(m_con);
        try
        {
            con.Open();
            Response.Write("成功!");
        }
        catch
        {
            Response.Write("失败!");
        }
输出结果:失败

Answer 1

调试,看一下exception...呵呵.一下子就知道是因为什么了..

Answer 2

Data Source=
这个修改后还是失败

Answer 3

System.Data.OleDb.OleDbException: 找不到可安装的 ISAM。 在 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() 在 _Default.Page_Load(Object sender, EventArgs e) 
 

Answer 4

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\excel\file\ado.xls;User id=admin;password=;Extended Propertice=Excel 8.0;
连接字串