User manual

Chapter 5 | Sharing and exchanging data 122
9. If you are importing data from an Excel file, you can import data by worksheet or by named range.
10. The new layout appears in Browse mode in Table View. You can update data, add an empty
record to the file, or add a new field to the layout.
For more information about setting up recurring imports, see Help.
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.
To Do this
Import data by worksheet Select Display worksheets, select the worksheet you want
to import, then click Continue.
Import data by named range, one worksheet or
named range per layout
Select Display named ranges, select the named range you
want to import, then click Continue.
To Do this
Update data Click the script button at the top of the new layout.
Add an empty record to the file (appears as a
blank row at the bottom of the table)
Click + at the bottom of the table.
Add a new field to the layout (appears as a blank
column on the right in the table)
Click + in the table heading.
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 126 and Help
1 One-time, static via ODBC import (or
File menu > Open)
1 Import Records script step
1 Execute SQL script step
Help