Importing excel data to SQL server

See more:

SQL-Server

MS-Excel

C#5.0

, +

Hello Everyone ,

I am trying to import multiple excel files into sql server through import wizard .
The files contain a big list of names and email addresses .
The problem after finishing import of one file ( I have created a ID column into destination table , auto increment ) , the rest files don't have the ID sequences in order .

How can I append the rest files , based the auto incrementing id number based on the last .

I cannot edit the SQL in the import wizard

What I have tried:

I tried adding a field in thje excel sheet .
enabling identity insert , it didn't help