I know of no way to do that and some of what you show is not relevant to FileMaker Table definitions. There are no such things as "begin and end positions" like you might find in Ye Olde Hollerith Cards....
I think i would need more info on the "field name, beginning position, ending position, and data format" information.
to determine whether those needs to be fields in a table or records.
Maybe some more information would help. I want to import a data file in to a Filemaker DB. I get this file each month and is contains several thousand data records. The file has fixed length records and each data field within the record has a defined beginning and ending record position (not delimited in any way, like a mainframe data file). The vendor provides a definition of each data record in an Excel file like the example I provided (simplified for example). If I was going to import the data file in to Excel, I would need to use the import wizard and define field by field using the wizard. I could do that then export the resulting excel file to Filemaker however there are several hundred data fields so I am trying to find a shortcut. Any help?
I guess your vendor does not change the dictionary file at every data pushing. The minimum you can ask is to get a warning when they do so.
For the rest, it's not a problem - import the data into a text field and process every line splitting the line into field values via Middle (line; beg pos; end pos - beg pos + 1).
There is no way to create (new) fields in FileMaker based upon using rows from an excel file, only by using the first line.
There is a paste function within Excel that would let you copy all of the rows in the names column and paste transpose into the first row of another sheet which pastes the names all in the first row.
You could then open this new Excel worksheet in FileMaker and FileMaker will create a table with all of the fields named.
If you manually input one line of your data file into the corresponding columns in the second row of your new Excel worksheet, FileMaker will also use Excel's guess as to data type to set the field type in FileMaker.
You would still need to check your field types but some of the data entry work of creating your FileMaker table would be done.
You would finally need to process the data file as suggested above.
check the calendar, mine says January 2017.