Hmmm... if I define the table in FMPro, I can import the Excel records appropriately. But I got the impression that I could create the table directly from the Excel file. Am I incorrect on that impression?
Open the Excel file from Filemaker Pro. Select the type of Excel (xls or xlsx). It is best to prep the Excel file, if it does not already have the column headings on row one, then do that. These are your field names.
- Drag the excel file on the FileMaker icon in the dock
- if You have an empty FileMaker file allready open, select 'import' from the menu, select the excel file - and then choose 'new table...' for the destination table
- if You have an existing FileMaker file open with existing fields, rearrange the import order in the import dialog
Thanks, guys. I am all set.