导入Excel文件错误：System.Data.OleDb.OleDbException（0x80004005） [英] Importing Excel file error: System.Data.OleDb.OleDbException (0x80004005)

问题描述

我使用OleDbConnection导入xlsx文件。

但是得到错误：

< pre lang =xml> System.Data.OleDb.OleDbException（0x80004005）：System.Data.OleDb.OleDbConnectionFactory.CreateConnection（DbConnectionOptions）上System.Data.OleDb.OleDbConnectionInternal..ctor（OleDbConnectionString constr，OleDbConnection连接）的未指定错误System.Data.ProviderBase.DbConnectionClosed处的System.Data.ProviderBase.DbConnectionFactory.GetConnection（DbConnection owningConnection）处的System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection（DbConnection owningConnection，DbConnectionPoolGroup poolGroup）处的options，Object poolGroupProviderInfo，DbConnectionPool pool，DbConnection owningObject） .OpenConnection（DbConnection outerConnection，DbConnectionFactory connectionFactory）在System.Data.OleDb.OleDbConnection.Open（）

代码如下：

  string  strPath =  @  D：\inetpub \wwwroot \ cffTemp \ BuildingScorecardTemplate2014321115842072920729。 xlsx 
 
 
  if （！File.Exists（strPath））
 {
 file.SaveAs（strPath， true ）; 
} 
 
  string  strConn =   Provider = Microsoft.ACE.OLEDB.12.0; Data Source = + strPath +  ;扩展属性= \Excel 12.0; HDR =是; IMEX = 1; FMT =定界\; 
 
  string  worksheetName =   ; 
 OleDbConnection conn =  new  OleDbConnection（strConn）; 
 conn.Open（）; 
 DataTable dtNew; 
 dtNew = conn.GetOleDbSchemaTable（OleDbSchemaGuid.Tables， null ）; 
 
 
 conn.Close（）; 
 

请帮助我。

请帮助我。

解决方案

看看这里：使用ADO.NET处理Excel文件 [ ^ ]

Hi,

I importing xlsx file using OleDbConnection.
But getting error as:

System.Data.OleDb.OleDbException (0x80004005): Unspecified error at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open()

Code as Below:

string strPath = @"D:\inetpub\wwwroot\cfxTemp\BuildingScorecardTemplate2014321115842072920729.xlsx"


if (!File.Exists(strPath))
{
    file.SaveAs(strPath, true);
}

string strConn =  "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strPath + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1;FMT=Delimited\"";

string worksheetName = "";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataTable dtNew;
dtNew = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);


conn.Close();

PLEASE HELP ME.
Please help me.

解决方案

Have a look here: Using ADO.NET to work with Excel files[^]

这篇关于导入Excel文件错误：System.Data.OleDb.OleDbException（0x80004005）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！