OLE DB提供程序“Microsoft.ACE.OLEDB.12.0”尚未注册。 [英] The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.

问题描述

大家好，

我正在执行以下查询，但是它给出了一个错误，说

Hi all,
I am executing following query but its giving an error saying that "

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.

"

SELECT
  * FROM
  OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=D:\New\Albany_ActPlan_2008_1Record.xlsx;HDR=YES;IMEX=1',
  'SELECT * FROM [Albany_ActPlan_2008_1Record]') AS POND;

任何人都可以帮我解决这个问题问题。



谢谢和问候

prakash.ch

could any one help me out to resolve this problem.

Thanks and Regards
prakash.ch

推荐答案

信息我发现MSDN上的帖子帮助我解决了这个问题：

HOW TO：FIX ERROR - 'microsoft.ace.oledb.12.0'提供程序未在本地计算机上注册 [ ^ ]

Information I found in this posting on MSDN helped me solve this problem:
HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine"[^]

检查这是否有效



EXEC sp_addlinkedserver

@server ='Server1'，

@srvproduct ='Excel'，

@provider ='Microsoft.ACE.OLEDB.14.0'，

@datasrc ='D：\New \ Albany_ActPlan_2008_1Record.xlsx; HDR = YES; IMEX = 1'，

@provstr ='Excel 14.0; IMEX = 1; HDR = YES;'



SELECT * FROM Server1 ... TableName

Check this will work

EXEC sp_addlinkedserver
@server = 'Server1',
@srvproduct = 'Excel',
@provider = 'Microsoft.ACE.OLEDB.14.0',
@datasrc = 'D:\New\Albany_ActPlan_2008_1Record.xlsx;HDR=YES;IMEX=1',
@provstr = 'Excel 14.0;IMEX=1;HDR=YES;'

SELECT * FROM Server1...TableName

这篇关于OLE DB提供程序“Microsoft.ACE.OLEDB.12.0”尚未注册。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！