Tutorial

Lesson 12
|
Sharing and exchanging data 87
3. For Files of type (Windows) or Show (Mac OS), choose All files (Windows) or All Available (Mac OS),
then choose MyFile.fp7 in the Tutorial folder.
MyFile.fp7 is the file you created in lesson 4 and the source file for this importing example.
4. Click Open.
The Import Field Mapping dialog box appears.
5. For Target, select Current Table (“Members”).
6. For Import Action, select Add new records.
7. Make sure that the First Name field under Source Fields is on the same row as the First Name field under
Target Fields.
You can move target fields up and down in the list using the slider. Place the pointer over the double-arrow
to activate the slider.
8. Repeat step 7 for Last Name.
9. Make sure that an appears between both the First Name fields and the Last Name fields.
If you don’t see an between matching fields, click to change the setting.
The remaining fields should have a between them. The data in these fields will not be imported to the
target file.
10. Click Import.
11. In the Import Options dialog box, click Import.
12. Review the information in the Import Summary dialog box, then click OK.
Records in MyFile.fp7 that contain first name and last name data have been added to Sample Copy.fp7.
The current found set contains the newly imported records. Browse the new records to verify the
imported data. Click Show All in the status toolbar to see all records in the file.
13. When you are finished with this lesson, close the sample file by choosing File menu > Close.
Fields in the
source file
Fields in the
target file
Arrows show that data will
import into the fields at right
Import
action
Source file to
import from
Target file to import
data into