none
SSMS导入Excel时提示未在本地计算机上注册“Microsoft.ACE.OLEDB.12.0”提供程序 RRS feed

  • 问题

  • 计算机环境系统:windows 10 1903 内部版本号:18362.175

    ssms版本:SQL Server Management Studio V18.1 

    详细版本:15.0.18131.0

    SQL Server Management Studio 15.0.18131.0
    Microsoft Analysis Services 客户端工具 15.0.1347.0
    Microsoft 数据访问组件 (MDAC) 10.0.18362.1
    Microsoft MSXML 3.0 6.0 
    Microsoft Internet Explorer 9.11.18362.0
    Microsoft .NET Framework 4.0.30319.42000
    操作系统 10.0.18362

    Microsoft Excel office 365 MSO (16.0.10.48.20020) 64位

    AccessDatabaseEngine_X64.exe

    出现的问题情况是:

     在使用ssms导入Excel数据到sql数据库的时候,提示:未在本地计算机上注册“Microsoft.ACE.OLEDB.12.0”提供程序

    相关环境及错误提示截图如下:

    系统相关环境及错误提示

    详细的错误提示代码有:

    未在本地计算机上注册“Microsoft.ACE.OLEDB.12.0”提供程序。 (System.Data)

    ------------------------------
    Program Location:

       在 System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
       在 System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
       在 System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
       在 System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
       在 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
       在 System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       在 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       在 System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       在 System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       在 System.Data.OleDb.OleDbConnection.Open()
       在 Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetOpenedConnection(WizardInputs wizardInputs, String connEntryName)
       在 Microsoft.SqlServer.Dts.DtsWizard.Step1.OnLeavePage(LeavePageEventArgs e)

    现在需要微软这边提供技术支持,以便我们处理数据库相关方面的问题,用于数据分析。

    希望得到各位大神的帮助,谢谢!


    • 已编辑 bill.bo 2019年8月5日 18:20
    2019年8月5日 17:12

全部回复

  • Hi bill.bo,

    可能你的Import/Export Wizard正在作为32位版本启动。 这可能是由于你右键单击数据库并单击导入,并启动了SSMS的32位进程。 请尝试从开始菜单中直接启动64位的Import/Export Wizard。

    希望这能帮助到你。

    Regards,

    Kyle


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2019年8月6日 2:20
    版主