U.M. (Windows)

Importing and exporting data 8-9
Importing data into a new file
You can bring data from another application into a new FileMaker Pro
file with one Standard layout and one columnar report. Every record is
copied into the new file.
1. In FileMaker Pro, choose Open from the File menu.
2. In the Open File dialog box, select from the drop-down list the type
of file you want to import, select the file from the list, and then
click Open.
3. In the New File dialog box, type a name for the new file, select a
location, and then click Save.
FileMaker Pro creates a text field called fx for each field in the new
file, where x is 1, 2, 3, and so on, until all fields are named.
Note If you’re importing from a format that contains the field names
(like DIF), FileMaker Pro uses the names instead of fx.
Some formats (including ClarisWorks and DBF) create number, date,
and time field types in addition to text.
If you are importing a Microsoft Excel file which contains more than
one worksheet, FileMaker Pro displays the Select Worksheet dialog
box from which you can select the worksheet that you want to import.
To stop the import, press Esc. You can delete the records already
imported by choosing Delete All from the Mode menu.
Exporting data from FileMaker Pro
You can export FileMaker Pro data to a new file, and then open it in
another application.
Keep these points in mind:
1 To use an exported file, open an application that can read the file
format, and then open the file. See “Understanding file formats” on
page 8-3 for file formats you can export.
1 You can export data in container fields to FileMaker Pro format.
Choose FileMaker Help Index from the Help menu, and then type:
E importing data
?