User manual

Importing and exporting data | 165
ODBC and JDBC
You can exchange FileMaker Pro data with ODBC- and JDBC- compliant
applications. For example, you can chart FileMaker
Pro data in Microsoft
Excel.
Methods of importing data into an existing file
When you import data into an existing file, you can:
1 add new records to an existing table
1 create a new table from imported data
1 update existing records in an existing table
1 update matching records in an existing table
Important The import options that update existing records and update matching
records both overwrite existing data during the import process and cannot be
undone. To safeguard your data, choose File menu > Save a Copy As to make a
backup of the file before you perform an import that updates records.
The file you import records from is the source. The file you import records to
is the target.
What do you want to do? How do you do it? See
Use FileMaker Pro as a data
source/share FileMaker
Pro data
1 SQL queries
1 JDBC
FileMaker ODBC
and JDBC Guide
Use FileMaker Pro as an ODBC
client/access ODBC data
Interactively via the
relationships graph
“Working with
external data sources”
on page 170 and
FileMaker Pro Help
1 One-time, static via ODBC
import (or File menu >
Open)
1 Import Records script step
1 Execute SQL script step
FileMaker Pro Help
φμπ10_υσερσ_γυιδε.βοοκ Παγε 165 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ