Make a copy of the spreadsheets.
Select all the spreadsheets. Drop them on Filemaker Pro Icon.
There will be a database created for each spreadsheet. The fields will be names field01, field02, etc
You can rename the fields.
This will get the data into Filemaker and make it a bit easier to manipulate.
If I do that, then I end up having to copy/paste the database fields from the various tables into one table, correct? This action does not create one database. IS there no way to add fields on import to an existing database?
For the first spread sheet, select Import records and specify "New table" as the target table. This imports the data from the first file and creates a new field for each spreadsheet column imported. You can then import from the other 5 spread sheets and the rows of data will be appended to the records created by the first import. You can then repeat for all your spreadsheet files to get a combined table of all your data.
Fore each subsequent import, this does not add additional fields to the existing table, only additional records. 1 spreadsheet row = 1 filemaker record.
If you want to import data from a 2nd file, but import the data into different fields, you'll need to open Manage | Database | Fields and add the fields manually. You'll also have to import the data with care in order to correctly update your existing records so that data from row 1 in file 2 is used to update the newly added fields in record 1 from the first import.