Setting up recurring imports
You can set up a FileMaker Pro file to automatically update data imported from another file, such as a Microsoft Excel spreadsheet. Recurring import occurs automatically every time you open the file and the first time you view the layout containing the data from the external file. Later, you can run a script to update data.
When you set up recurring imports, FileMaker Pro creates a new table for the imported data and a new layout to display the data. You can customize the layout in Layout mode later, if you wish.
Each time you update data, FileMaker Pro deletes data in the recurring import layout and replaces it with current data from the external file. Data imported via recurring import cannot be modified or added to in FileMaker Pro.
Note  To set up recurring imports, you must open a file with an account that is assigned the Full Access privilege set. For information about privilege sets, see About accounts, privilege sets, and extended privileges. Users do not need to use an account with Full Access privileges to use recurring import after it has been set up in a file.
To set up recurring imports:
In Browse mode, choose File menu > Import Records > File.
For Files of type (Windows) or Show (Mac OS), select the type of file you want to import. For example, choose Excel Workbooks (*xlsx).
For a list of supported file types, see Supported import/export file formats.
Select Set up as automatic recurring import, then click Open.
The path of the file you selected appears in the Recurring Import Setup dialog box.
To skip importing column headings, select Don’t import first record (Contains field names).
Note  You can import data from only one worksheet or named range per layout.
Select Display worksheets, select the worksheet you want to import, then click Continue.
Select Display named ranges, select the named range you want to import, then click Continue.
The new layout appears in Browse mode in Table View. For more information about Table View, see Viewing records as a form, list, or table.
Recurring import is an import-only process. To make changes to the data, first modify data in the source file. Next import data in the FileMaker Pro file by clicking the script button on the recurring import layout. If changes are made to the data while the FileMaker Pro file is closed, data on the recurring import layout will update the first time you view the layout during your next FileMaker Pro session.
When data is imported for the first time, FileMaker Pro creates an Import log file in the folder that contains the FileMaker Pro file. This log file is updated each time data is imported into any FileMaker Pro file located in this folder.
When you use the script button to update data, FileMaker Pro deletes all previously imported records, reimports the data, and creates new records for any new data found in the external file.
The automatically generated script FileMaker Pro creates for recurring import is not supported in a FileMaker Server scheduled script.
Related topics 
Importing data into an existing file