none
The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) RRS feed

  • Question

  • Hi ,

    I am facing issue in importing the data which is in Microsoft Excel 2016 to MSSQL via SSMS (Management Studio). It throw an error :

    "===================================


    The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)


    ------------------------------

    Program Location:


       at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)

       at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)

       at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

       at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)

       at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)

       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)

       at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)

       at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)

       at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

       at System.Data.OleDb.OleDbConnection.Open()

       at Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetOpenedConnection(WizardInputs wizardInputs, String connEntryName)

       at Microsoft.SqlServer.Dts.DtsWizard.Step1.OnLeavePage(LeavePageEventArgs e)

    Tuesday, August 27, 2019 9:48 AM

All replies

  • Seems ACE is not installed (as 32 bit Provider) on the machine, you can get it here: Microsoft Access Database Engine 2016 Redistributable => AccessDatabaseEngine.exe

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, August 27, 2019 10:21 AM
  • Hi Paramanand Dubey,

    SSMS is a 32 bit client, if your Microsoft Excel is 64 bit. you may need to install the 64 bit version of the Microsoft Access Database Engine 2016 Redistributable and try opening - the 64-bit  "SQL Server Import and Export Data" directly. Go to Start Menu -> Microsoft SQL Server 2017( your SQL server version) ->  SQL Server  Import and Export Data (64-bit)> Open the application and try to import data using the "Excel 2016" option, it should work fine.

    Best regards,
    Cathy

    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

    Wednesday, August 28, 2019 2:25 AM
  • Thanks for the support.

    Here I have install Office 32 bit and Access Database Engine 32 bit. after these installation, it is working fine.

    We got success in the error. Now it has been resolved.

    Tuesday, September 3, 2019 2:49 PM
  • Yes, You are right. But we need Office 32 bit also to resolve the error.

    Fortunately, after installation of Office 32 bit and access database engine 32 bit, It is working.

    Thanks for your support.

    Tuesday, September 3, 2019 2:51 PM
  • A complete MS Office Installation is not required, ACE data Provider ist quite enough.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, September 3, 2019 2:55 PM
  • No, Actually without excel 32 bit. it was not working.

    After installation of 32 bit excel or office SUIT 32 bit along with Access database engine 32bit, than it started working.

     
    Tuesday, September 3, 2019 2:58 PM