SQL server

Question

I installed the SQl server 2022 and the SSMS but it keeps showing the same error everytime i try to import a excel document.

Answer 1

Hi @lucio rodrigues,

You need to install Microsoft ACE OLEDB provider.

Here is its download links:

• Version 12.0: https://www.microsoft.com/en-us/download/details.aspx?id=13255
• Version 16.0: https://www.microsoft.com/en-us/download/details.aspx?id=54920

Answer 2

Hi lucio rodrigues •

If you encounter a similar error as mentioned in the thread below, kindly apply the provided mitigation and verify if it resolves your situation.

https://learn.microsoft.com/en-us/answers/questions/512631/cannot-import-excel-files-to-ssms-but-possible-usi

Thank you!

Answer 3

Hi @lucio rodrigues

it keeps showing the same error everytime i try to import a excel document.

You'd better post the error message.

If the error is Microsoft.ACE.OLEDB.16.0 Provider is not registered on the local machine.Please check the version of Excel and SSMS. They need to be same, like 32 vs 32 or 64 vs 64. SSMS is a 32-bit client, if your Microsoft Excel is 64-bit. you may need to install the 64-bit version of the Microsoft Access Database Engine 2016 Redistributable and try opening – the 64-bit “SQL Server Import and Export Data” directly.

Go to Start Menu -> Microsoft SQL Server 2017( your SQL server version) -> SQL Server Import and Export Data (64-bit)> Open the application and try to import data using the “Excel 2016” option, it should work fine.

If it is not work, please try the other solutions from this blog: How to Fix The “Microsoft.ACE.OLEDB.16.0 Provider is not registered on the local machine.”

Best regards,

Cosmog Hong

---

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.