install the driver on your local machine:
https://www.microsoft.com/en-us/download/details.aspx?id=54920
also are you current on SSMS (v21)?
unable to import data into SSMS
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 30%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Damodara Kuntrapaku
0
Reputation points
HI Team,
Am unable to import data into SSMS from network location.
ERROR: TITLE: SQL Server Import and Export Wizard
The operation could not be completed.
ADDITIONAL INFORMATION:
The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)
BUTTONS:
OK
I have downloaded AccessDatabaseEngine_X64, but still am facing issues. Since I was using All SQL application are 64bit version. I was unable to use 32bit version.
Could you please help asap.
Regards,
Damodara
Developer technologies | Transact-SQL
2 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com) 79,101 Reputation points Volunteer Moderator2025-08-12T17:34:38.9666667+00:00 -
Erland Sommarskog 124.3K Reputation points MVP Volunteer Moderator2025-08-12T21:31:59.9166667+00:00 Which version of SSMS are you using? SSMS 20 and earlier are 32-bit, and you need the 32-bit version of the driver. (The fact that SQL Server itself is 64-bit is irrelevant.)
SSMS 21 is 64-bit so that should work, but I have not actually tried it.