Are there any validation field options set on those FileMaker fields that might reject the data you are trying to import?
Do you see any pattern as to which fields fail to import?
Is this a case where the data imports from some rows of your spreadsheet and not others or is this a case where no data from any row of the spreadsheet is imported into that specific field?
Have you double checked to be sure that the column in question has been mapped to a field in your target table? (Or are you using the new table option?)
Validation field options are off. The name and phone number fields import fine, but some other text fields won't import, and the date fields won't import. All rows import at least the name and phone #, but no row imports into the Member field, for instance. I have double-checked that the Member field in the import file is mapped to the Membership Status field in the FMP db.
I have not been able to discern any sort of pattern. The name fields are text fields and import find, but the Member field is also text and will not. The phone number field imports fine, but the date fields will not. I can't see any difference between the text fields that will import and those that don't. They are all set to Text format in Numbers before exporting as csv or Excel.
I am really stumped!! What could it be?
As a test, try this.
Drag and drop your file onto the FileMaker Application icon.
This should create a brand new FileMaker file with a brand new table into which all of your data has been imported.
See if this "from scratch" file and table holds all of your info or if it has the same problems as you see with your attempts to import the data into your current table.
OK, I did that and it imported all fields. There was one little hitch, but it's nothing I can't handle and they are all there. So that seems to say that it's something with how the fields in the other table are formatted, doesn't it?
Or maybe not. The data is in columns A through AB in the Numbers file (so 28 columns). Nothing after column O (email address) imports. Could there be some defect with the flle that's causing it?
That's what this test was intended to investigate. If all columns of data appear in this new table, it suggests an issue with the table in your original file, though the "Format" is unlikely to be the issue.
But if only some of the columns import in this test table, that suggests either a problem with your import file or with FileMaker.
Thanks for your help.