Error Inserting Row

[TangoResearch]

I am trying to update a table via import and keep getting "Error Inserting Row". Data appears to be fine and there are no conflicts with unique fields. what does this error mean. Hundreds of import have gone fine on this table except for this one little set.

[LWSChad]

Search for a character that could be messing with the import. I encountered this before, and I think it was an apostrophe.

 

Search for and omit...

' (apostrophe)

, (comma)

; (semi-colon)

` (tilde)

There could be more, but I bet it's a special character problem

[TangoResearch]

Thank you. I think that worked. The offending character was in a text field that I was able to eliminate and it worked so I don't know what character caspio was having a problem with. 

 

One interesting thing is that this particular text field had been successfully imported for the previous four days. Weird.