User manual

12-4 FileMaker Pro User’s Guide
• If you’re updating records, make sure the found set contains only
the records you want to update. Records outside the found set will
not be updated, even if match field data matches.
5. In Browse mode, choose File menu > Import Records > File.
6. In the Open File dialog box, to see all the files in the current folder
that you can import: for Files of type (Windows) or Show (Mac OS),
choose All Files. To narrow the choices, choose a file type from the
list.
7. Select the name of the file to import, then click Open.
8. If you’re importing a Microsoft Excel file that contains multiple
worksheets or named ranges, select the worksheet or range that you
want to import in the Specify Excel Data dialog box and click OK.
9. If you’re importing a Microsoft Excel file, you see the First Row
Option dialog box. Choose whether the first row of data in the file is
field names or data.
Double-headed arrows indicate
Data or fields in
the source file
Null symbols show data
match fields for import update
Arrows show that data will
import into the field at right
Choose an
Re-order
all fields
Fields in the
destination file
import action
that won’t be imported
10. In the Import Field Mapping dialog box, perform the next three
steps before you click Import.
You can also perform either of these actions at any time before you
click Import:
To Do this
View the data in the file Click the Scan Data arrows to see the data in each �
you’re importing from record.�
(Optional)�
Create, change, or Click Define Fields. In the Define Fields dialog box, �
delete a field in the file make your changes, then click Done. (For more �
you’re importing into information about defining, changing, and deleting �
(Optional) fields, see chapter 5, “Creating a database.”) If you’re �
importing into a shared file, only the host can create
fields. If the button is dimmed, your access privileges
don’t allow you to define fields.
11. In the Import Field Mapping dialog box, choose the type of
import you want to perform.
Choose To
Add new records. Add new records to the end of the
file you’re importing into
Replace data in current found set. Replace data in this file with data
from the source file, in order,
starting with the first record in
each file
Update matching records in current found set. Update data in the found set of
To add records in the found set of the source
this file with data in matching �
file that do not have matching records in the
records in the file you are �
destination database, also select Add
importing from�
remaining records.
12. In the Import Field Mapping dialog box, line up each field in the
Fields in list with the data or field you want to import into it or match
for import update.