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.
12,638 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,450 questions
{count} vote

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 32,426 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.