如何在本地计算机上注册“microsoft.ace.oledb.12.0” [英] How do I register 'microsoft.ace.oledb.12.0' on my local machine

问题描述

Microsoft Excel的连接字符串：

 OLEDBconnectionString =   Provider = Microsoft.ACE.OLEDB.12.0; Data Source = C：\Users\User \Documents\file.xlsm; Extended Properties ='Excel 12.0 Macro; HDR = YES'; 

错误代码：

'Microsoft.ACE.OLEDB。 12.0'提供商未在本地计算机上注册。 
 
如何在我的本地机器上注册Microsoft.ACE.OLEDB.12.0？

< b>我尝试过：



已添加参考文献：Excel 14.0，DOA，OLE等



1）

 OLEDBconnectionString =   Provider = Microsoft.ACE.OLEDB。 12.0;数据源= C：\Users\User \Documents\file.xlsm;扩展属性='Excel 8.0宏; HDR = YES'; 

2）

 OLEDBconnectionString =   Provider = Microsoft.JET.OLEDB.4.0; Data Source = C：\Users\User \Documents\file.xlsm; Extended Properties ='Excel 4.0 Macro; HDR = YES'; 

解决方案

正确的连接字符串是：

 Provider = Microsoft.ACE.OLEDB.12.0; Data Source = c ：\myFolder\myExcel2007file.xlsm; 
扩展属性=Excel 12.0宏; HDR = YES; 

请参阅： Excel连接字符串 - ConnectionStrings.com [ ^ ]

Connection String for Microsoft Excel:

OLEDBconnectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\User\Documents\file.xlsm;Extended Properties='Excel 12.0 Macro;HDR=YES';"

Error code:

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

How do you register 'Microsoft.ACE.OLEDB.12.0' on my local machine?

What I have tried:

Added References: Excel 14.0, DOA, OLE, etc.

1)

OLEDBconnectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\User\Documents\file.xlsm;Extended Properties='Excel 8.0 Macro;HDR=YES';"

2)

OLEDBconnectionString="Provider=Microsoft.JET.OLEDB.4.0;Data Source=C:\Users\User\Documents\file.xlsm;Extended Properties='Excel 4.0 Macro;HDR=YES';"

解决方案

A proper connection string is:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsm;
Extended Properties="Excel 12.0 Macro;HDR=YES";

See: Excel connection strings - ConnectionStrings.com[^]

这篇关于如何在本地计算机上注册“microsoft.ace.oledb.12.0”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！