Excel not importing a certain field...
First, apologies if this was previously discussed. I searched the forums, but my searches yielded all sorts of results that didn't pertain to my problem.
I'm trying to import records into my database from an excel spreadsheet. Everything is importing correctly, except one field. I can scroll through the import field mapping and everything is correct. My field "DailyRate" is matching all the records correctly, but for some reason Filemaker isn't importing that information into the database.
The field is a number field, specifically currency.
Any reason why?