Problem with data pumping

[SqlHunter]

This is pretty straight forward.Iam pumping data from an excel sheet and the destination table in the sql server has an incremental primary key so its not allowing me to do the data pumping..
what should I do

 

[JayKusch]

When you start importing the excel sheet into the table using DTS, you will come to a screen that says "Select Source Tables and Views". There you will see 3 sections. The first being "Source", then "Destination", then "Transform".

Click on the section that has the elipse (...) and says "Transformation". The next screen presented will have a couple of check box options.

UNCHECK the check box that says "Enable Identity Insert". Now let it rip ... should go for you now!

Thanks

J. Kusch

 

[SqlHunter]

I tried that but for some reason it wasn't allowing it was saying that iam inserting null values to the primary key.I created a sequence in the code and did it and it worked.So for now my work is done but i was wondering what could be the problem.