Forum Discussion
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 tasks>import file, the Wizard opens and after indicating the datasource, I get the following error message:
2. If I go to Start and use the SQL Server 2022 Import and Export Data (64-bit) in my pc Apps, I get this error:
3. If I try importing in the csv format and import as a flat file, I get the following error message:
can anyone help please?
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.
I also noticed that the redistributable Olafhelper is not version 12.SivertSolem , indeed, because that version is out-of-support and therefore there is no public download available.
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
RDP2024 , as the message say, the data provider ACE for Office files isn't registered, you have to install it first.
