Share via

Cant import Excel into SQL Management Studio

Keith Banbury 0 Reputation points
2024-06-14T14:21:45.66+00:00

I too can't import Excel files using the SSMS Wizard. I get the following error message

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

I am running Office 2013 that doesn't include 'Access' on Windows10. I have SSMS v20, my Office apps were installed as 32bit but I have reinstalled as 64bit now.

I have tried a number of the options in the threads but so far nothing has worked. I have attempted to install SSIS v1.4 and v1. For some reason although they download they don't install even when run as admin.

This is what I see in SQL

SQLOLEDB {0C7FF16C-38E3-11d0-97AB-00C04FC2AD98} Microsoft OLE DB Provider for SQL Server

Microsoft.ACE.OLEDB.12.0 {3BE786A0-0366-4F5C-9434-25CF162E475E} Microsoft Office 12.0 Access Database Engine OLE DB Provider

Microsoft.ACE.OLEDB.16.0 {3BE786A2-0366-4F5C-9434-25CF162E475E} Microsoft Office 16.0 Access Database Engine OLE DB Provider

ADsDSOObject {549365d0-ec26-11cf-8310-00aa00b505db} OLE DB Provider for Microsoft Directory Services

MSOLEDBSQL {5A23DE84-1D7B-4A16-8DED-B29C09CB648D} Microsoft OLE DB Driver for SQL Server

Search.CollatorDSO {9E175B8B-F52A-11D8-B9A5-505054503030} Microsoft OLE DB Provider for Search

MSDASQL {c8b522cb-5cf3-11ce-ade5-00aa0044773d} Microsoft OLE DB Provider for ODBC Drivers

MSOLAP {DBC724B0-DD86-4772-BB5A-FCC6CAB2FC1A} Microsoft OLE DB Provider for Analysis Services 14.0

MSDAOSP {dfc8bdc0-e378-11d0-9b30-0080c7e9fe95} Microsoft OLE DB Simple Provider

I suspect that missing SSIS is the issue but just don't know.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,129 questions
0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Satya Prakash 80 Reputation points
    2024-06-14T14:25:34.3933333+00:00

    The error message "The 'Microsoft.ACE.OLEDB.15.0' provider is not registered on the local machine" suggests that the required OLE DB provider for Excel is not properly installed or registered on your system. Here are the steps you can follow to resolve this issue:

    Install the Microsoft Access Database Engine:

    • Download and install the Microsoft Access Database Engine 2016 Redistributable. This will include the necessary OLE DB providers.
      • You can find the download link here.
      • Make sure to download the version (32-bit or 64-bit) that matches your SQL Server Management Studio (SSMS) installation.

    Check SSMS Version and Architecture:

    • Ensure that the version of SSMS you are using matches the architecture of the Microsoft Access Database Engine you installed. If you installed the 64-bit version of the Access Database Engine, ensure SSMS is also 64-bit.

    Re-register the OLE DB Provider:

      - After installing the Access Database Engine, you may need to re-register the OLE DB provider. Open a command prompt as an administrator and run the following commands:
  
  ```powershell
  shCopy code
  regsvr32.exe 
  ```
  
     - Adjust the path to the `ACEOLEDB.DLL` file based on your Office installation directory and version.
     
     **Verify Installation**:
     
        - After installation, verify that the OLE DB provider appears in the list of providers in SSMS. You should see entries for `Microsoft.ACE.OLEDB.12.0` or `Microsoft.ACE.OLEDB.16.0`.
        
        **Configure Data Source in SSMS**:
        
           - When using the Import and Export Wizard in SSMS, ensure that you select the correct OLE DB provider (e.g., `Microsoft.ACE.OLEDB.16.0`) for the data source.
           
           **Check for SSIS Installation**:
           
              - While SSIS (SQL Server Integration Services) is not directly related to the OLE DB provider registration, ensure that you have the necessary components installed. You can try reinstalling SSIS if you suspect that its absence might be affecting your setup.
              
              **Run SSMS as Administrator**:
              
                 - Sometimes, running SSMS with elevated privileges can resolve issues related to provider registration and access.
                 
                 **Check Office Installation**:
                 
                    - Since you mentioned you reinstalled Office apps as 64-bit, ensure that there are no remnants of the 32-bit installation that might be causing conflicts.

    By following these steps, you should be able to resolve the issue with the Microsoft.ACE.OLEDB.15.0 provider not being registered on your machine. If the problem persists, ensure that there are no additional configuration issues or system restrictions that might be affecting the registration of the OLE DB provider.

  2. Yitzhak Khabinsky 25,556 Reputation points
    2024-06-14T18:46:22.3566667+00:00

    Hi @Keith Banbury,

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

    Here is Microsoft Access 2013 Runtime (Microsoft.ACE.OLEDB.15.0) download link:

    https://www.microsoft.com/en-us/download/details.aspx?id=39358

    You can install 64-bit edition at the command prompt with the additional flag: c:>AccessRuntime_x64_en-us.exe /quiet

  3. Satya Prakash 80 Reputation points
    2024-06-14T14:28:40.8833333+00:00

    The error message "The 'Microsoft.ACE.OLEDB.15.0' provider is not registered on the local machine" suggests that the required OLE DB provider for Excel is not properly installed or registered on your system. Here are the steps you can follow to resolve this issue:

    Install the Microsoft Access Database Engine:

    • Download and install the Microsoft Access Database Engine 2016 Redistributable. This will include the necessary OLE DB providers.
      • You can find the download link here.
        • Make sure to download the version (32-bit or 64-bit) that matches your SQL Server Management Studio (SSMS) installation.
        Check SSMS Version and Architecture: 
        - Ensure that the version of SSMS you are using matches the architecture of the Microsoft Access Database Engine you installed. If you installed the 64-bit version of the Access Database Engine, ensure SSMS is also 64-bit.
    1. Re-register the OLE DB Provider:
      • After installing the Access Database Engine, you may need to re-register the OLE DB provider. Open a command prompt as an administrator and run the following commands: 
             shCopy code
     regsvr32.exe
      • Adjust the path to the ACEOLEDB.DLL file based on your Office installation directory and version.
      Verify Installation:
      • After installation, verify that the OLE DB provider appears in the list of providers in SSMS. You should see entries for Microsoft.ACE.OLEDB.12.0 or Microsoft.ACE.OLEDB.16.0.
      Configure Data Source in SSMS: 
        - When using the Import and Export Wizard in SSMS, ensure that you select the correct OLE DB provider (e.g., `Microsoft.ACE.OLEDB.16.0`) for the data source.

  **Check for SSIS Installation**:

     - While SSIS (SQL Server Integration Services) is not directly related to the OLE DB provider registration, ensure that you have the necessary components installed. You can try reinstalling SSIS if you suspect that its absence might be affecting your setup.

     **Run SSMS as Administrator**:

        - Sometimes, running SSMS with elevated privileges can resolve issues related to provider registration and access.

        **Check Office Installation**:

           - Since you mentioned you reinstalled Office apps as 64-bit, ensure that there are no remnants of the 32-bit installation that might be causing conflicts.

    By following these steps, you should be able to resolve the issue with the Microsoft.ACE.OLEDB.15.0 provider not being registered on your machine. If the problem persists, ensure that there are no additional configuration issues or system restrictions that might be affecting the registration of the OLE DB provider.

    4o

  4. Michael Taylor 50,426 Reputation points
    2024-06-14T14:37:46.4+00:00

    I'm confused as to what you have installed.

    I am running Office 2013

    But then later

    my Office apps were installed as 32bit but I have reinstalled as 64bit now.

    You cannot have both x86 and x64 versions of Office installed. SSMS is an x86 app and therefore will use the x86 Data Sources.

    My followup question is what are you doing to import the file. Are you using the import a flat file option (which is for CSV files) or import data (which supports multiple providers). If you're using import data then you have to select a data source provider. You should be using Excel if that is what you're importing.

  5. ZoeHui-MSFT 34,591 Reputation points
    2024-06-17T02:47:09.59+00:00

    Hi @Keith Banbury,

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

    Please try to install both 32bit and 64bit driver.

    https://datasavvy.me/2017/07/20/installing-the-microsoft-ace-oledb-12-0-provider-for-both-64-bit-and-32-bit-processing/

    https://www.microsoft.com/en-us/download/details.aspx?id=54920

    Regards，

    Zoe Hui

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

    0 comments