Import Excel that does not have default to SQL SERVER with C # [closed]

1

I have the following scenario: I have an Excel spreadsheet that is provided by several private companies. This worksheet contains social security data. The problem is this: I have columns that refer to company data and columns that refer to the participant; the problem is that the name of the columns that refer to the company are the same names that refer to the participant, and the only point that distinguishes this separation between both is a grouping made by a header as shown below: I need to insert into the sql server database but the spreadsheets can come with the order of the columns changed, which makes it difficult to insert the data into the table by position. Does anyone know how I can enter the data correctly in the bank without putting the values of the company in the participant and vice versa?

    
asked by anonymous 28.12.2018 / 12:10

0 answers