Querying an ODBC data source from FileMaker ProAfter configuring an ODBC client driver, you can interact with records, import records into an existing FileMaker Pro database file, or create a new FileMaker Pro database file from an ODBC data source (such as Oracle or Microsoft Access databases).Important See Connecting to data sources for information on how you can access and work with ODBC data sources without writing SQL queries.You can access your ODBC data source through the File menu, with the Import Records script step, or with the Execute SQL script step.All applications that support ODBC recognize a basic subset of SQL (Structured Query Language) statements. SQL is passed through the ODBC interface to the data source, performing queries such as SELECT first_name, last_name FROM customers WHERE city=N'Paris' and making updates such as the creation of a new record with INSERT INTO customers (first_name, last_name) VALUES (N'Jane',N'Smith').
• To import into an existing FileMaker Pro file, choose File menu > Import Records > ODBC Data Source.
• To create 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).
2. Choose your data source and click Continue.To skip this dialog box in the future, select Save user name and password (this option is only available if you’re importing into an existing FileMaker Pro file).
4. Click OK.You can execute the query immediately, or copy and paste it into a field for later use. Use the Import Records or Execute SQL script step to execute a query stored in a field. See Storing an SQL query in a field for details.
6. Click Execute.
•