sql-server-2008 - "The ' Microsoft.ACE.OLEDB.12.0 ' provider is not registered on the local machine"将 xlsx 导入到 SQL Server 的过程中出错

Question

我有 64 位 Windows 7 和 SQLServer 2008 R2(64 位)

我按照 here 的说明进行操作将 excel 文件导入到 sql server 但在该帖子的图 3 部分中，当我尝试访问 excel 文件时，当我单击“下一步”时，此错误让我停止:

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

我在网上搜索我知道我必须安装AccessDatabaseEngine_x64。但是当我安装它时我遇到了同样的问题

你能帮我做什么吗？

Answer 1

安装以下内容来解决您的错误。

2007 Office System Driver: Data Connectivity Components

AccessDatabaseEngine.exe (25.3 MB)

This download will install a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access 2007 (*.mdb and .accdb) files and Microsoft Office Excel 2007 (.xls, *.xlsx, and *.xlsb) files to other data sources such as Microsoft SQL Server.