Executing SQL to interact with data sources via ODBC
In addition to importing data into a FileMaker Pro database file via ODBC, you can also interact with data sources (such as Microsoft SQL Server and Oracle) using SQL statements through the Execute SQL script step. You can use any SQL statement supported by the data source, such as INSERT, UPDATE, and DELETE.
You can also use SQL statements that go beyond simply importing data into a FileMaker Pro database file. For example, you could execute SQL statements that add records to a database table in SQL Server, using information from a FileMaker Pro database file.
To execute SQL statements against a data source via ODBC:
1.
Choose Scripts menu > Manage Scripts.
2.
Click New.
3.
Add the Execute SQL script step to the script.
It appears in the Miscellaneous category.
4.
Select the Execute SQL script step and click Specify.
5.
In the Specify SQL dialog box, click Specify.
6.
Select your data source and click Continue.
You might be asked for a user name and password.
7.
In the Specify SQL dialog box, enter your SQL statements.
See your data source documentation for a listing of supported SQL statements and their syntax.
8.
Click OK.
Related topics 
Constructing an SQL query for importing via ODBC
Was this topic helpful? Send feedback.