Installation and New Features Guide (Windows)

5-16 FileMaker Pro Installation and New Features Guide
Importing the results of the query into FileMaker Pro
After building the SQL query in the Specify ODBC SQL Query dialog
box, you’re ready to import the resulting records into FileMaker Pro.
1. In the FileMaker Pro Import Field Mapping dialog box, match the
fields you want to import on the right with the data source columns
on the left by selecting Matching Names from the View By list.
You can also drag the FileMaker Pro fields on the right side to line up
with the ODBC columns on the left (for example, move the
Salesperson_ID field on the right up to the first position, and so on).
2. Make sure the columns on the left have an arrow to their right
between the column name and the field name.
3. Click Add new records, and then click Import.
4. If you see the Import Options dialog box, select options, then
click OK.
Seven records should be imported into the Sales Reports database. To
stop importing, press Esc (Windows) or Command-period (Mac OS).
To delete the records already imported, choose Delete All from the
Mode menu.
Choose Matching
Names if column
names match
FileMaker Pro field
names
FileMaker Pro Import Field Mapping dialog box
Columns must be aligned with
FileMaker Pro field names
To import data, there must be an arrow
between the column and field name
Click to add new records
Click to import
records