79408446

Date: 2025-02-03 10:20:00
Score: 0.5
Natty:
Report link

I had this problem too.

SSDT is a 32-bit application, so you must register Microsoft.ACE.OLEDB.16.0 32-bit on your system. So download 32-bit accessdatabaseengine.exe from here https://www.microsoft.com/en-us/download/details.aspx?id=54920.

Then run CMD as administrator and goto downloaded accessdatabaseengine.exe folder by cd command like this:

C:\Users\RAHIMY> cd C:\Users\RAHIMY\Downloads

After all, run this command and wait a moment:

C:\Users\RAHIMY\Downloads> accessdatabaseengine.exe /quiet

Now restart your SQL Server Management Studio and now you can import your Excel files from SSMS (Right click on your Database->Tasks->Import Data...).

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Low reputation (0.5):
Posted by: Yousef Rahimy Akhondzadeh