Thank you for your post.
In Excel, is the apostrophe a straight apostrophe or a curly apostrophe? If curly, this may be a translation problem when importing into FileMaker Pro. I've previously used Excel but I don't know if there is a preference to set that option.
Anybody with Excel experience?
Thanks for the response. It appears that it was just the view was set to the wrong encoding. Thanks. (Sorry for the long response, had to get out of town fast when my father passed away.)
I am currently experiencing the same issue that you were having. A black diamond with a white question mark appears in my import. You mentioned that the issue was because the view was set to the wrong encoding, would you mind explaining this further? I'm a autodidactic filemaker user so I'd really appreciate the help. I've been maintaining and slowly improving the database over the past 4 years and everything was working as it should be until last week. I went away on holidays and (not blaming it on my coworkers) when i returned the issue was there.
Thanks in advance,