How to fix SQL Server Management Studio Import and Export Wizard External component has thrown an exception

Question

I have a simple Excel sheet with data I'm attempting to import into SSMS. I select the sheet from a database Tasks -> Import Data, the Import wizard lets me select the sheet, but when I click next I recieve this error:SQL Server Import and Export Wizard The operation could not be completed.

ADDITIONAL INFORMATION:
External component has thrown an exception. (System.Data)

The excel sheet security is set to me, it is in a subfolder and I've checked several versions of the Access runtime. The data upload worked previously. I'm hoping someone can shed some light on this error.

Answer 1

Hi @Duane Bentzen

Ensure that your Excel file is in a supported format. Try saving the Excel file as an .xls (Excel 97-2003) format if it is currently .xlsx (Excel 2007 or later).

Besides, check SQL Server logs which might provide more detailed information.

Best regards,

Cosmog

---

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".