AnsweredAssumed Answered

Importing into FileMaker 16 (Formatting Issue)

Question asked by bonamatt on Apr 4, 2018
Latest reply on Apr 4, 2018 by philmodjunk

Hi everyone,

 

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.

Outcomes