Importing new field names and data from Excel to existing FM Pro 8 table - possible?
Every year, I need to perform this daunting task of adding 200+ new field names to a new layout in our FileMaker Pro 8 database table. Instead of going to Define Fields and adding new field names one by one, is there a way to import the new field names and data from an Excel file to an existing FM Pro table? I know how to do a simple export and match field names, but what if there are extra fields in the import file (200+) that I really would rather not have to add manually? Please tell me there is a batch upload solution! And I'm not talking about creating a new table or database--I want to append our current table with the additional fields and data from the Excel file.
Thanks in advance!!