Key violations or some crap

[Sarge, USMC]

So when I import data to one of the tables in my DB, I get this message:



I donno what this is all about. The records I'm importing do import normally. No data is lost.

I didn't have this problem last year when I used the DB. This year, I had to change some of the headers, but that's it.

Any ideas what this might be all about?

[Sarge, USMC]

Lots of views, no feedback. Anyone got any ideas at all what this might be about?

[pbaldy]

I saw this then and didn't have a good thought. Are you sure no data is truncated, like trying to put a 30 character value into a text field set to 20?

[Micron]

This year, I had to change some of the headers,

This smells like you changed a data type in the target table and now you can't append from a source where the corresponding field is of an incompatible type. It's a very generic message that provides clues for which you have to really focus on, which is why I'm not suggesting something like key violations (that one is zero). Maybe post a bit more about what's coming from where and what it's going into and how, unless you check out my guess and find that's the problem.

[orange]

Do you have a table with "Import Errors" or similar in its name?
As micron said, tell us/show us a little more.

What specifically did you change? From what, to what?

[CJ_London]

the other possible smell is use of reserved words in column names, with or without spaces. Would also be helpful to know what process of importing you are using.