“Microsoft.ACE.OLEDB.16.0"提供程序未在本地计算机上注册.(系统.数据)

2021-12-30 00:00:00 excel sql-server ssis oledb aceoledb

当我尝试通过 MSSQL Server 数据导入(即 SSIS 包)连接到任何 excel 时出现此错误 Microsoft.ACE.OLEDB.16.0 提供程序未在本地计算机上注册.(System.Data)

I get this error when I try to connect to any excel through MSSQL Server Data Import i.e. SSIS package The Microsoft.ACE.OLEDB.16.0 provider is not registered on the local machine. (System.Data)

这不是同一个版本,我认为需要一些其他修补

It is not the same version I think some other patching is needed

推荐答案

对于在尝试上述方法后仍然卡在这个问题上的任何人.如果您右键单击数据库并转到任务-> 导入,那么问题就在这里.转到开始菜单并在 sql server 下,找到 x64 位导入导出向导并尝试.对我来说就像一个魅力,但我花了太长时间才找到它微软!

For anyone that is still stuck on this issue after trying the above. If you are right-clicking on the database and going to tasks->import, then here is the issue. Go to your start menu and under sql server, find the x64 bit import export wizard and try that. Worked like a charm for me, but it took me FAR too long to find it Microsoft!

相关文章