(Naam='PANTY'S, NYLONS' )
I guess this is a clear Xpath/OQL/SQL injection issue which needs to be fixed asap by whoever maintains the excel importer.
Excel bug ?? Is an injection issue. Should suspect you can solve this by creating a MF to change the apostrophe into a double apostrophe, but that does not work.
You can still create a microflow while you wait for the next version: 1. Create a MF which changes the apostrophe in something you can uniquely distinguish (like "'"). 2. Add the MF to the attribute you import (Parse with in the Template). 3. Add a retrieve action after the import in the Import MF to find all values with unique indicator and make a Onchange loop to change all value back to the apostrophe.
Since you are using the Panty field as key field best is not only to make a change and copy to another attribute (and use that another attribute for displaying values in Mendix)
This an excel importer bug, if you have specified a column as object key and it contains a character such as ' " or a line break. The XAS will throw an exception
You can rename your value to panties like Marc suggested ;-)
The other option is to wait for the next release, this might take a week or two before the version is updated. If you have some sort of critical deadline please contact our partner manager (floor, jan-mark, ramses)
It's not a modeling answer, but your item is named Panty's? Wouldn't it be Panties?
Also, are you importing it as a string?