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

Deborah Dollesin 0 Reputation points
2024-06-10T18:28:21.98+00:00

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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,070 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,581 Reputation points
    2024-06-11T05:39:58.6733333+00:00

    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.

    0 comments No comments