在Quering Excel 2010中诊断OLEDB异常

3 回答

• 1

  也许您卸载了Access数据库引擎（ACE）组件？它们仍然可以从MSDN下载2007 Office System Driver: Data Connectivity Components .

  回复于 2024-05-06T19:19:16+08:00
• 2

  我相信Excel 2010它是：

  Dim excelConnectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Password="""";User ID=Admin;Data Source=D:\\MyDocs\\oledb.xlsx;Mode=Share Deny Write;Extended Properties=""HDR=YES;"";Jet OLEDB:Engine Type=37"
  

  这似乎在我的视觉工作室中工作，我得到Excel生成查询字符串，它有额外的条目 .

  回复于 2024-05-06T19:19:16+08:00
• 7

  我按照上面的建议下载并安装了Office System Driver：Data Connectivity Components - 以下代码有效：

  string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Password=\"\";User ID=Admin;Data Source=d:\\Sample.xlsx;Mode=Share Deny Write;Extended Properties=\"HDR=YES;\";Jet OLEDB:Engine Type=37";
  
      OleDbConnection connection = new OleDbConnection(connectionString);
  
      try
      {
          connection.Open();
  
          OleDbCommand command = new OleDbCommand("SELECT * FROM [Sheet1$]", connection);
          OleDbDataAdapter adapter = new OleDbDataAdapter();
          adapter.SelectCommand = command;
  
          DataSet ds = new DataSet();
          adapter.Fill(ds);
  
          GridView1.DataSource = ds;
          GridView1.DataBind();
  
      }
      catch (Exception)
      {            
          //throw;
      }
      finally
      {
          connection.Close();
      }
  

  回复于 2024-05-06T19:19:16+08:00