Installation and New Features Guide (Windows)

5-12 FileMaker Pro Installation and New Features Guide
3. For column information, click the Guess button. The ODBC driver
will attempt to retrieve the column names from the specified table.
It may take a few moments to retrieve the column names.
4. Specify the information for the Salespeople table.
In the Table list, choose Salespeople.
You’ll be prompted to save changes to the table definition. Click Yes.
5. Click the Guess button to retrieve the column names for the
Salespeople table, then click OK. Click Yes to save changes, then click
OK again.
Importing from the data source
After you’ve specified and configured the data source, you can open
your FileMaker Pro 4.1 database and import ODBC data. There are three
general steps involved in importing data with ODBC:
1 specifying the data source in FileMaker Pro
1 creating a SQL query using the Select, Where, and Order by clauses
1 importing the results of the SQL query into FileMaker Pro
Click Guess to
insert column
names
Select to retrieve column
names from the ODBC table