First post so go easy on me . I am currently using FileMaker 16. I am importing some data from a excel spreadsheet (survey data), and I am having some issues since I updated from FileMaker 12 to FileMaker 16. When I import the data from the excel spreadsheet into FileMaker 16 the string text responses change into a numbers (i.e 4, 43, 24). And any "Yes" or "No" string text response is coming in as numbers. The rest of my database (old data) is perfectly fine and showing up correctly, but something is going on with importing now that I updated my FileMaker. This was never a issue when I was using FileMaker 12.
One of my co-workers remembered there was a single button/checkbox option on FileMaker 12 to fix this issue, but we can't figure it out in FileMaker 16.
Any help would be greatly appreciated.