How to convert several Excel files into one FM-File?
No problem to convert a Excel-File into a Filemaker File.But how can I convert/import a second Excel-File as a second table in the same FM-File?
You can import into a new table. When the import dialog comes up, one of the options in the pull down on the right side is "new table". It may force you to name the new table whatever the Excel file is, but you can change the name in Manage Database after the import.
The key is to use Import Records as Mark suggests and not drag and drop as the drag and drop method always generates a new file.
That would be great. But I am too stupid to find the pulldown menu. Could you please post a screenshot? Thank you very much!
Launch Filemaker and either open an existing database or create a new one.
Select Import Records from the File menu.
Import records has a lot of options you can choose so it's a good idea to research this tool in FileMaker help before you attempt to use it.
Now I found the "the pull down on the right". Thank you very much for your help!!!
Retrieving data ...