服务器上不装excel2003,程序需要用Provider=Microsoft.Jet.OLEDB.4.0,读取excel表里面的数据,有什么方法解决没?
DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb");
DbHelper help = new DbHelper("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + excelPath + ";Extended Properties=Excel 8.0", factory);
DbConnection con = help.CreateConnection();
DbCommand cmd = help.CreateCommand();
cmd.CommandText = "select distinct * from " + table + "";
DataTable dt = null;
try
{
con.Open();
dt = help.ExecuteDataTable(cmd);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
con.Close();
}
return dt;
DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb");
DbHelper help = new DbHelper("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + excelPath + ";Extended Properties=Excel 8.0", factory);
DbConnection con = help.CreateConnection();
DbCommand cmd = help.CreateCommand();
cmd.CommandText = "select distinct * from " + table + "";
DataTable dt = null;
try
{
con.Open();
dt = help.ExecuteDataTable(cmd);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
con.Close();
}
return dt;
或使用connectionString="Provider=Microsoft.Jet.Oledb.4.0;
data source=|DataDirectory|db1.mdb"