User manual

15-8 FileMaker Pro User’s Guide
5. To sort records before importing, click the ORDER BY tab, then
specify the name of the column to sort by and whether the sort should
be ascending or descending.
6. When you’re finished constructing the query, click Execute, then
map the ODBC columns to FileMaker Pro fields.
Note You can also type a SQL statement directly into the SQL
Query box.
Importing the results of the query into FileMaker Pro
After executing the SQL query, you’re ready to import the resulting
records into FileMaker Pro. For information on importing data into a
FileMaker Pro database, see “Importing data into FileMaker Pro” on
page 12-2.
An ODBC import example
To help you get acquainted with importing data from ODBC sources,
there is a sample database, Sales Reports, and two text files,
Salespeople and Sales_Data, that you can import from.
1 The Salespeople table has information for seven employees, such
as their name, their manager’s name, their sales region, and their
employee identification number.
1 The Sales_Data table has 250 records tracking sales that the
employees have made.
In the next three sections, you’ll import data from the tables by
creating SQL statements. You can then evaluate the imported data in
the Sales Reports database.
Using the WHERE SQL statement
Creating a SQL join
Select Matching Names if column names
match FileMaker Pro field names
FileMaker Pro Import Field
Mapping dialog box
Align columns with
field names
Choose a
mapping option
Specify how
records are
imported
Click to import
records