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?
Not sure what you mean by:
My field "DailyRate" is matching all the records correctly,
Does this mean that you are importing using one of the "matching records" options or did you specify just the "add new records" option that is the default?