Importing data into FileMaker ProWhen you import data, you’re bringing data from another source (usually a file) into an existing FileMaker Pro file. If you want to create a new FileMaker Pro file from another file format, see Converting a data file to a new FileMaker Pro file.FileMaker Pro can import many different file formats. For a list of file formats that FileMaker Pro supports, see Supported import/export file formats.The source file does not need to have the same number of fields in the same order as the target file. During the import process, you can arrange the target fields so that the source data imports into the correct fields, as well as skip fields that you don’t want to import.Important Some of the above options can overwrite existing data in your file. See Methods of importing data into an existing file.
• You can import data from any field type into any compatible field except calculation and summary fields. You can only import into container fields if you're importing from another FileMaker Pro file or importing a folder of image files. When you import data into a global field, the last item imported into the field from the source file determines the global field value.
• You can only import data into a single table at a time. To import data into related fields, import data directly into the table that contains the related field.
• If you routinely import data from the same source, you can automate the process by setting up recurring imports or by creating a script that uses the Import Records script step. Data imported via recurring import is read-only in FileMaker Pro. For more information about recurring imports, see Setting up recurring imports. For more information about using a script to import records, see Creating scripts to automate tasks and Import Records script step.