Share via

Cant import Excel into SQL Management Studio

Keith Banbury 20 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,226 questions
0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Keith Banbury 20 Reputation points
    2024-06-20T11:40:51.9166667+00:00

    Thanks to all who took the trouble to post an answer.

    I have now been able to resolve the problem. In the end I have used suggestion that were commonly supplied. I believe this problem was a result of a number of issues.

    • Having Office 2013 installed as 32bit (no Access database in my installation) - resolved in part by reloading as 64bit.
    • I have v20.0 of SSMS installed that is 64bit but I believe the import wizard may be 32bit?
    • I had to load another program before I could load the ACE redistribution
    • I loaded ACE OLEDB 16 64bit redistribution software but had to force the loading of the 32bit. note. the x86 32bit version did not work. I can now get past this stage in the import process for excel but I have to select
    1. Microsoft Excel 2016 - (2013 doesn't work)
    2. For Destination I have to select 'Microsoft OLE DB Provider for SQL Server

    I can see the local Server and database I am working with on my laptop in the Wizard, but it currently wont connect, but that is another question for later if I can't resolve it. Looks like security or a port issue.