User manual

15-10 FileMaker Pro User’s Guide
6. Select the Date_Sold column and verify that the Type and Mask
values are correct.
The Type should be Date, and the Mask should be m/d/yy.
When importing columns that store date information, you should
verify that the driver recognizes the correct column type and mask,
especially if the data source is from a Unix computer.
7. Click OK.
This saves the information for the Sales_Data table.
8. Specify the information for the Salespeople table by following
steps 2-7 above.
Click the close box to close the control panel.
Specifying the tables and columns in the Mac OS
After choosing and configuring the ODBC text driver in the ODBC
control panel, you specify the tables and columns to import.
1. In the Mac OS, click the Define tab.
The Sales_Data table appears in the Table pop-up menu. If
Salespeople appears, switch to the Sales_Data table.
2. Select the Column Names in First Line checkbox.
3. For column information, click the Guess button. The ODBC driver
retrieves the column names from the specified table.
4. Specify the information for the Salespeople table.
For Table, 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.
Connecting to the ODBC Demo data source
To connect to the ODBC Demo data source from FileMaker Pro:
1. Open the Sales Reports file, located in the ODBC Example folder.
2. In Browse mode, choose File menu > Import Records.
3. Choose the file import format.
Windows: For Files of type, select ODBC Data Sources.
Mac OS: For Show, select ODBC.
4. In the Select ODBC Data Source dialog box, select ODBC Demo, then
click OK.
Click Guess to insert column names
Select to
retrieve column
names from the
ODBC table
Click Guess to insert column names
Select to
retrieve column
names from the
ODBC table