Tried importing excel sheet to Microsoft SQL server and been getting the error message sayingthe MICROSOFT.ACE.OLEDB.16.0 is not registered on your local machine(SYSTEM DATA). How fo i solve this issue?

Pritam g 6 Reputation points
2022-08-25T09:05:19.293+00:00

Please help me out as soon as possible

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,432 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,641 questions
{count} vote

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 40,356 Reputation points
    2022-08-25T09:18:42.677+00:00

    Hi @Pritam g ,

    MICROSOFT.ACE.OLEDB.16.0 is not registered on your local machine(SYSTEM DATA).

    It seems that ACE is not installed on the machine, you can download it here:Microsoft Access Database Engine 2016 Redistributable

    You may download the 32bit for that SSMS or Visual Studio is a 32 bit client.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.