This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(16, 2%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
I clicked on the next button to import my data from excel and it brings me this error message;
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
NOTE: THE DOWNLOAD LINK IS NOT WORKING
I AM STUCKED PLEASE I NEED HELP.
Have you installed the ACE provider? If so, have you installed the 32-bit version and are using the 64-bit version of the wizard or vice versa?
Please check this video: How to Fix SQL Database ODBC Driver Error.
As a quick workaround, try save your excel file to 97-2003. Or convert it to a CSV file.
Also, see this similar thread for more possible solutions.
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".
@LiHongMSFT-4306 Thanks. This was helpful.