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.