I'm using SS 2008 R2 and Office 2010 on a Windows 7 64 bit. I am trying to use the import wizard to import an excel sheet into a table. I get this error:
我在Windows 7 64位上使用了SS 2008 R2和Office 2010。我正在尝试使用import向导将excel表导入到表中。我得到这个错误:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)
I am very new to this and would greatly appreciate any help I can get.
我对这方面非常陌生，非常感谢我能得到的任何帮助。
Incidently, I also may be doing this wrong (and therfore getting the error) because if I choose the 64 bit import wizard there is no option for Microsoft Excel. So, I am trying to use the 32 bit wizard. Does anyone know how I can get this to work? Thanks in advance!
顺便说一下，我可能也做错了(在得到错误之前)，因为如果我选择64位导入向导，Microsoft Excel就没有选项了。所以，我正在尝试使用32位向导。有人知道我怎么能把它弄出来吗?提前谢谢!
For other users: For anyone who has this same problem, The answer that a1ex07 suggested works for Office 2010 as well. Check this thread The 'Microsoft.ACE.OLEDB.12.0' provider is not registered in the local machine
对于其他用户:对于任何有同样问题的用户，a1ex07建议的答案也适用于Office 2010。检查这个线程“Microsoft.ACE.OLEDB.12.0”提供程序没有在本地机器中注册。
3 个解决方案
#1
5
I was having the same problem trying to import an Excel file using SQL Management Studio (SMS 2012). I use 64-bit version of everything including Office 2013. This solution from social.msdn.microsoft.com solved it for me:
我在尝试使用SQL Management Studio (SMS 2012)导入Excel文件时遇到了同样的问题。我使用64位版本的所有东西，包括Office 2013。这个来自social.msdn.microsoft.com的解决方案为我解决了:
The problem you are likely having is the Import/Export Wizard is being launched as the 32-bit version. This is probably due to you right clicking on a database and clicking on import and since SSMS is a 32-bit program it will launch 32-bit processes. Try explicitly running the Import/Export Wizard (64-bit) by clicking on Start->Program Files->Microsoft SQL Server 2012->Import and Export Data (64-bit) to import your data from a 64-bit datasource.
您可能遇到的问题是导入/导出向导作为32位版本被启动。这可能是由于您右键单击数据库并单击import，由于SSMS是一个32位程序，它将启动32位进程。通过单击Start->程序文件->Microsoft SQL Server 2012->导入和导出数据(64位)，尝试显式地运行导入/导出向导(64位)，从64位数据源导入数据。
Noral Kuhlmann
Noral了
#2
2
For anyone who has this same problem, The answer that a1ex07 suggested works for Office 2010 as well. alex07's answer The 'Microsoft.ACE.OLEDB.12.0' provider is not registered in the local machine ... this answer originally came from kd7.
对于任何有同样问题的人，a1ex07建议的答案也适用于Office 2010。alex07的答案是“Microsoft.ACE.OLEDB.12.0”提供程序没有在本地机器中注册…这个答案来自kd7。
#3
0
the file can be Excel 2007 try to install 2007 Office System Driver: Data Connectivity Components
该文件可以是Excel 2007尝试安装2007 Office系统驱动程序:数据连接组件。
#1
5
I was having the same problem trying to import an Excel file using SQL Management Studio (SMS 2012). I use 64-bit version of everything including Office 2013. This solution from social.msdn.microsoft.com solved it for me:
我在尝试使用SQL Management Studio (SMS 2012)导入Excel文件时遇到了同样的问题。我使用64位版本的所有东西，包括Office 2013。这个来自social.msdn.microsoft.com的解决方案为我解决了:
The problem you are likely having is the Import/Export Wizard is being launched as the 32-bit version. This is probably due to you right clicking on a database and clicking on import and since SSMS is a 32-bit program it will launch 32-bit processes. Try explicitly running the Import/Export Wizard (64-bit) by clicking on Start->Program Files->Microsoft SQL Server 2012->Import and Export Data (64-bit) to import your data from a 64-bit datasource.
您可能遇到的问题是导入/导出向导作为32位版本被启动。这可能是由于您右键单击数据库并单击import，由于SSMS是一个32位程序，它将启动32位进程。通过单击Start->程序文件->Microsoft SQL Server 2012->导入和导出数据(64位)，尝试显式地运行导入/导出向导(64位)，从64位数据源导入数据。
Noral Kuhlmann
Noral了
#2
2
For anyone who has this same problem, The answer that a1ex07 suggested works for Office 2010 as well. alex07's answer The 'Microsoft.ACE.OLEDB.12.0' provider is not registered in the local machine ... this answer originally came from kd7.
对于任何有同样问题的人，a1ex07建议的答案也适用于Office 2010。alex07的答案是“Microsoft.ACE.OLEDB.12.0”提供程序没有在本地机器中注册…这个答案来自kd7。
#3
0
the file can be Excel 2007 try to install 2007 Office System Driver: Data Connectivity Components
该文件可以是Excel 2007尝试安装2007 Office系统驱动程序:数据连接组件。