The 'Microsoft.ACE.OLEDB.15.0' provider is not registered on the local machine. (System.Data) When Trying to Import Excel 2013 file into SSMS 18

Add an entry from SSMS:

Tools>>External tools to point to this 64-bit version:

Add:

Type a meaningful name for Title , like ImportExcel for example;

Type the following path (default install of SQL Server 2019) for Command:

C:\Program Files\Microsoft SQL Server\150\DTS\Binn\DTSWizard.exe

You will see the new entry ImportExcel when you need to import Excel file from SSMS now.

With reference to the proposed solution, if someone is trying to run SSMS 18 on their local workstation to do a SQL import via SSMS 18, where a 64-bit version of Office is installed,

a) You will not have the 64-bit SQL Server 20xx Import and Export wizard installed since it is not part of the SSMS 18 install

and

b) You will not be able to install the 32-bit version of the ACE 15, because it will detect the 64-bit install of Office and prevent the installation of 32-bit ACE in any flavor

I suspect the only way around this would be to install the SQL Server 20xx tools or run this wizard on another machine. Given how common this scenario is - i.e. a developer on a new workstation with SSMS 18/Office development tools, it seems like there should be a better solution than having to install SQL Server 2019 tools or uninstalling 64-bit Office (which I can't do).

Hi @RyM_3 ,

Welcome to Microsoft Q&A.
This warning message appears when the SQL Server Import and Export Wizard is launched via SSMS which is a 32-bit application and the 32-bit version of the SQL Server Import and Export Wizard is launched, but you have installed the Microsoft Access Database Engine 2016 Redistributable (Microsoft.ACE.OLEDB.15.0) 64-bit version.
To resolve it, you can launch 64-bit version of the SQL Server Import and Export Wizard via the Start menu, then find and expand Microsoft SQL Server 20xx.

Or you can install the Microsoft.ACE.OLEDB.15.0 32-bit version, then you can continue using the SQL Server Import and Export Wizard via SSMS.
(Edit) You can install Microsoft.ACE.OLEDB.15.0 32-bit using with the file path and file name of the 32-bit Access Database Engine install file, followed ‘/quiet’. In this way, you can install 32-bit without uninstalling 64-bit first.

Please refer to this article which might help.
Best Regards,
Amelia

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.