Using SQL Server 2019 Import and Export Data

Question

Hello,
When opening SQL Server 2019 Import and Export Data (64-bit), I choose a Data Source, it displays Microsoft Access (Microsoft.ECA.OLEDB.16.0) in the drop-down list. I can import Excel file into SQL Server.

However, I use Microsoft SQL Server Management Studio, choose a database and right-click on it, choose Tasks --> Import Data. When selecting Data Source, there is Microsoft Access (Microsoft.ECA.OLEDB.16.0) in the drop-down list. I want to import data from Excel file into SQL Server, it will display error message "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)"

How can I change to fix this issue?
Thanks,

Answer 1

Hi @63345710 ,

Please issue the following statement in SSMS to check what Microsoft ACE providers are installed:

EXEC master.sys.sp_MSset_oledb_prop;  

In the wizard, you need to select Data source: Microsoft Excel.
After that Excel version dropdown.
The available options functionality depends on the installed Microsoft ACE providers.

Answer 2

Hi @63345710 ,

SQL Server Management Studio (SSMS) is 32-bit applications and only install 32-bit files, including the 32-bit version of the wizard.

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

It seems that you have not install the 32bit provider.

You may refer this to installing-the-microsoft-ace-oledb-12-0-provider-for-both-64-bit-and-32-bit-processing.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.