Importing data into FileMaker Pro
When 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.
If FileMaker Pro does not support the format of a particular application, you may still be able to convert the data by exporting data from that application in a format that FileMaker Pro does support. For example, FileMaker Pro does not import Microsoft Access files, but you can export the data from Microsoft Access to a format that FileMaker Pro does support, and then import that file.
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.
When you import data into an existing FileMaker Pro file, you can:
 •
 •
 •
Important  Some of the above options can overwrite existing data in your file. See Methods of importing data into an existing file.
Notes
 •
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.
 •
Related topics 
Querying an ODBC data source from FileMaker Pro
Importing and exporting dates
Topics in this section
Methods of importing data into an existing file
About creating a new table for imported data
About validating data during import
Importing data into an existing file
Setting up recurring imports
Importing a folder of files all at once
Importing XML data
Setting the import action and mapping fields during import