“Microsoft.ACE.OLEDB.12.0”提供者未在本地计算机上注册“将xlsx导入到sql server的错误 [英] "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" Error in importing process of xlsx to a sql server

问题描述

我有64位Windows 7和SQLServer 2008 R2（64位）

我按照这里将excel文件导入到sql server，但在图3中，当我尝试访问excel文件时，当我点击下一个这个错误让我停止：

 Microsoft.ACE.OLEDB.12.0提供程序未在本地计算机上注册
  

我搜索网络我知道我必须安装 AccessDatabaseEngine_x64 。
但是当我安装它我有一个相同的问题

你能帮助我做什么吗？

解决方案

该文件可以在excel 2007中制作，尝试安装：

2007 Office系统驱动程序：数据连接组件

AccessDatabaseEngine.exe（25.3 MB）

此下载将安装一组便于
数据传输的组件在现有的Microsoft Office文件之间，如
Microsoft Office Access 2007（* .mdb和 .accdb）文件和Microsoft
Office Excel 2007（ .xls，*。 xlsx 和* .xlsb）文件到其他数据
源，如Microsoft SQL Server 。

I have a 64 bit windows 7 and SQLServer 2008 R2 (64 bit)

I follow the instructions that are here to import excel file to sql server but in figure3 section of that post when I try to access excel file and when I click next this error make me stop:

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

I search the web i knew that I must install AccessDatabaseEngine_x64. but when I install it I have a same problem

Can you please help me what to do?

解决方案

the file can be made in excel 2007, try to install:

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.

这篇关于“Microsoft.ACE.OLEDB.12.0”提供者未在本地计算机上注册“将xlsx导入到sql server的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！