SQL Server Import and Export Wizard is showing error while importing files

Question

I am trying to import an excel file into SQL Server Management Studio and this error comes up:

An error occurred creating the configuration section handler for system.data: Column 'InvariantName' is constrained to be unique. Value 'MySql.Data.MySqlClient' is already present. (C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config line 157) (System.Configuration) ------------------------------ Column 'InvariantName' is constrained to be unique. Value 'MySql.Data.MySqlClient' is already present. (System.Data) ------------------------------ BUTTONS: OK ------------------------------

What would be causing this?

Answer 1

Hi @Deborah Dollesin,

Column 'InvariantName' is constrained to be unique. Value 'MySql.Data.MySqlClient' is already present.

Please check the column named InvariantName.

It seems that you are inserting a duplicate value to the column.

You should change the value in the table or change the value in your excel file.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.