Constructing an SQL query for importing via ODBCAfter you access your ODBC data source, use the SQL Query builder to construct and execute a query. Using the SQL Query builder, you construct queries that can search an ODBC data source or DBMS, fetch specific records, and import the resulting records into a FileMaker Pro database file.You can execute the query immediately, or store it in a field for repeated use. See Storing an SQL query in a field for details.
• If you’re importing into an existing FileMaker Pro file, choose File menu > Import Records > ODBC Data Source, and then choose your data source. The SQL Query builder dialog box appears (you might see a password and user name dialog box first).
• If you’re creating a FileMaker Pro file from the data source records, choose File menu > Open. In the Open dialog box, choose ODBC Data Source for Files of type (Windows) or Show (OS X), and then choose your data source. The SQL Query builder dialog box appears (you might see a password and user name dialog box first).
2. In the SELECT tab > Tables list box, click the table you want to import. The columns associated with this table appear in the Columns list box.
3. This constructs the SQL statement in the SQL Query box.
5. Click the WHERE tab to construct search criteria. This reduces the number of records that are imported. You can also join data from two tables.
6. 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.