Installation and New Features Guide (Windows)

ODBC import with FileMaker Pro 5-5
Importing ODBC data: an overview
The procedures to import ODBC data can vary depending on which
driver you are using. For example, the steps to import data using the
Oracle or SQL Server ODBC driver vary from the steps using the Text
driver. Additionally, steps may vary from one ODBC driver
manufacturer to another. Refer to the documentation available in the
retail version of the ODBC driver for more information.
Here are general steps to import ODBC data:
1. If necessary, install the ODBC driver.
2. In the ODBC control panel, choose the driver and data source.
3. Use the FileMaker Pro query builder to generate a SQL query.
The data resulting from the query can then be imported into a
FileMaker Pro 4.1 database.
An ODBC import example
To help you get acquainted with importing data from ODBC sources,
FileMaker Pro 4.1 includes a sample database, ODBC-compliant data,
and evaluation ODBC drivers. You can work through the examples in
this chapter using an ODBC text driver on your system, or you can
install the INTERSOLV evaluation drivers.
Use the ODBC example files, along with the instructions below, to
import ODBC data from two text files, Salespeople and Sales_Data.
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
FileMaker Pro Sales Reports database.