SQL server data import error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Rajapriya Rajendran 21 Reputation points
2024-02-21T09:09:56.7433333+00:00

Hi All, I'm attempting to import data into SQL Server from an Excel spreadsheet, but I consistently encounter an error message stating: "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" from the System.Data namespace. I use SQL server management studio (v18.10) and microsoft excel (version 2302 Build 16.0.16130.20848) 64-bit Could someone kindly assist me with resolving this issue. Thanks

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,690 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 32,586 Reputation points
    2024-02-21T09:34:52.1066667+00:00

    Hi @Rajapriya Rajendran,

    It is a 32-bit vs 64-bit issue.

    You may try to install the Microsoft.ACE.OLEDB Provider for Both 64-bit and 32-bit.

    Here is a blog you may take a reference.

    Regards,

    Zoe


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

    0 comments No comments