关于连接excel

[wanghao2979]

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("失败!");
}
输出结果:失败

[孤独侠客123]

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

[wanghao2979]

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

[wanghao2979]

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)

[wanghao2979]

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


连接字串