java excel 2010_尝试连接到excel 2010不起作用

我遇到了这个例外：'Microsoft.ACE.OLEDB.12.0'提供程序未在本地计算机上注册 .

我试图将Excel 2010文件与OleDBConnection连接 . 我有Windows 7 64位和Office 2010 32位 .

他们中的任何一个都不适合我 . 有人帮吗？

这是我的代码：string connectionString =“Provider = Microsoft.ACE.OLEDB.12.0; Data Source = d：\ Sample.xlsx; Mode = Share Deny Write; Extended Properties = \”HDR = YES; \“; Jet OLEDB：发动机类型= 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);

ds.Tables[0].Rows.Count.Dump();

}

catch (Exception)

{

throw;

}

finally

{

connection.Close();

}