Click here to Skip to main content
15,907,497 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
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
Updated 16-Jun-17 4:10am

1 solution

A lot of research proved that it's impossible .

The excel files need to be restructured to fit the data , and the missing columns need to be added .

I was able to insert data .
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900