AnsweredAssumed Answered

Importing new field names and data from Excel to existing FM Pro 8 table - possible?

Question asked by RebeccaRichter on Dec 2, 2013
Latest reply on Jun 19, 2017 by ahum

Title

Importing new field names and data from Excel to existing FM Pro 8 table - possible?

Post

     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!!

Outcomes