Forum Discussion
RDP2024
Jun 11, 2024Copper Contributor
Unable to Import Excel files into SQL Server
Hello SQL Team, I'm new to SQL Server & I just created a database and need to import an Excel file. The problem is that the 3 methods of importing the file has failed. If I use ta...
SivertSolem
Jun 11, 2024Iron Contributor
For the final results screen, clicking the "error" result will bring up the actual error message.
I also noticed that the redistributable Olafhelper is not version 12.
From the following Q&A article, it would appear that a solution is to choose Excel 2016 in the drop-down.
RDP2024
Jun 11, 2024Copper Contributor
I get the same error message if I select Microsoft Excel 2016. I called M365 support & after troubleshooting, they were unable to resolve, but they did confirm that since I have M365, I shold not need to download the 2016 product.
Very disappointing