c# - 未在本地计算机上注册“ Microsoft.ACE.OLEDB.12.0”提供程序('Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine)

Question

I'm trying to get data from an Excel file on a button click event.

(我正在尝试在按钮单击事件中从Excel文件获取数据。)

My connection string is:

(我的连接字符串是：)

 string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\source\SiteCore65\Individual-Data.xls;Extended Properties=Excel 8.0;";

When I click on the button, I got the following error:

(当我单击按钮时，出现以下错误：)

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

(“ Microsoft.ACE.OLEDB.12.0”提供程序未在本地计算机上注册。)

I have no clue how to fix this.

(我不知道如何解决这个问题。)

My operating system is Windows 7.

(我的操作系统是Windows 7。)

  ask by Shailesh Sahu translate from so

Answer 1

Well, you need to install it.

(好，您需要安装它。)

You're looking for:

(您正在寻找：)

• The 2007 Office System Driver: Data Connectivity Components .

  (2007 Office system驱动程序：数据连接组件 。)