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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi All,
I am unable to import the only XLSX excel extension to SQL Server PFA error.
I am in need of the quick and a permanent solution for this. Could you/some one please help me out to have a solution or at least a workaround to this. one of my collegue is using the 2019 version of SQL I was using the 2016 hence I have reinstalled the 2019 Version as well but it does seems to work still. The issue is only with XLSX files.
Thanks & Best Regards
Dinesh
![](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(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @Anonymous ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
The error message is pretty clear. OK, it is in Polish, and your name does not seem Polish, but nevertheless...
You need to install the ACE OLE DB provider. The error message suggests that you need version 12.0, but I believe there is a 16.0 provider.
Please download and install this redistributable and that should solve the issue. That should solve that error when using Excel documents as data source on SQL Server Management Studio Import/Export Wizard or when importing Excel files using SQL Server Integration Services (SSIS).
Hi @Anonymous ,
Welcome to Microsoft Q&A!
This happens may because of the choice of the wrong version (32-bit or 64-bit) of the SQL Server Import and Export Wizard. For example, if exporting data from the 64-bit version of SQL Server and using the SQL Server Import and Export Wizard via SSMS which is 32-bit application and include 32-bit version of the SQL Server Import and Export Wizard and, because of that, the above warning message will appear. To resolve this, launch 64-bit version of the SQL Server Import and Export Wizard.
For more information, please refer to this article: https://www.sqlshack.com/importexport-data-sql-server-using-sql-server-import-export-wizard/
Best regards,
Seeya
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.