Importing Excel File into FIlemaker
I am trying to import an excel file into an exisiting database and am having trouble with one thing... One part of the database we fill in multiple student names as they register for a contest. When I import though it only allows me to import the first student name and not any of the other group members. I don't know if this is something that I will have to change the database for or not.
What exists now is a page on the database for an entry that has a chart where we fill in student name and address. There are 5 spots on the chart for student names. The excel file has each student name listed in its own column. But I can only seem to import the first student name into the first slot, none other names show up.
FM treats Excel data as Record = Row not column.
You may have to format your excell data so that its in rows not columns for import