To answer the first question: If in the Excel file the field names are in the first row, you can just drag and drop them on the FileMaker icon.
Later, you can import the tables from the different FM files created into one file.
Antworten an: "email@example.com<mailto:firstname.lastname@example.org>" <email@example.com<mailto:firstname.lastname@example.org>>
Datum: Mittwoch, 18. April 2012 16:59
Betreff: Making/modifying lists of fields
We would like to create new tables in the DB from these XLS (or XLSX) files, such that all the Excel columns would become new fields in the FMP table.
You cannot *import* the fields into FM and have the fields named, but you can *open* the Excel file in FM and bring the names along.
Open the Excel file with FileMaker. You'll be asked if you want to convert the file, what to name it and where to save it.
Save your Excel file that has the column headings you would like to use as field names in row 1.
Open FileMaker. Choose Open file, locate the Excel file above and make sure the Show option is set to All Available.
Select the Excel file and click Open.
The First Row Option dialog will appear. Choose the Field Names option to have the first row used as field names.
Name the file and select where to save it in the next dialog. That should do it.
The fields will import as Text fields. You will need to change the type in FileMaker.
You would need to do this for each *table* you want in your new FM file. Once you have the field names, you could then copy/paste each file's table into the Main file you are creating.
Martin's response is the faster way to get to the Open dialog. It would replace the first 4 paragraphs in mine that explain how to open the Excel file once FM is open. His explanation will take you directly to the First Row Option dialog.
Your second question:
is whether there's a way to change properties of a group or set of fields, while making a db?
Unfortunately, no. I don't believe there is a way to change the properties of more than one field at a time. When you select more than one, Option dims and the available buttons are Duplicate, Delete and Copy. Create is also active, but not useful.
Thanks Martin and Michelle. Importing the Excel table does the trick.
Too bad there isn't more efficient handling of multiple fields in FMP. I wondered if that would be an improvement in 12, but I see no mention of that.