Appending data to a SQL table from excel

[khurley]

I need to append data on a monthly basis to a SQL table. The first column in the table it a PK identity column called P_ID.

When i try to append the data from excel using DTS it tells me i can't choose ignore for that column because i can't use nulls there. I also don't want to pass data to the column because i just want it to update automatically when i add the new data.

Any help would be greatly appreciated.

Kathy

 

[MaffewW]

Kathy,

see thread961-548380 it should allow you to choose to ignore if you uncheck the identity insert box. let us know if you need more help

 

[khurley]

PERFECT Thanks so much!!!!!!!!!!!!!!!!!!!!1

 

[khurley]

PERFECT Thanks so much!!!!!!!!!!!!!!!!!