U.M. (Windows)
Table Of Contents
- Preface: Getting help
- Chapter 1: FileMakerPro basics
- Chapter 2: Creating a database file
- Chapter 3: Laying out and arranging information
- Understanding layouts
- Working with predefined layout types
- Arranging records in columns
- Managing layouts
- Working with layout parts
- Changing layout parts
- Working with all object types
- Working with graphic objects
- Working with fields in a layout
- Adding fields to a layout
- Adding merge fields
- Deleting a field from a layout
- Defining display formats for fields
- Determining data entry in fields
- Setting the tab order for data entry
- Adding scroll bars to fields
- Formatting repeating fields
- Adding borders, fill, and baselines to fields
- Defining value lists
- Formatting fields with value lists
- Working with text
- Chapter 4: Working with information in records
- Working in Browse mode
- Adding data to a file
- Selecting a field for data entry
- Adding and duplicating records
- Entering and changing data in fields
- Working with container fields
- Entering data from a value list
- Viewing and inserting data from another source
- Copying and moving values and records
- Using drag and drop to move information
- Replacing field values
- Working with records
- Finding information
- Deleting records
- Sorting records
- Chapter 5: Using ScriptMaker and buttons
- Chapter 6: Previewing and printing information
- Chapter 7: Networking and access privileges
- Chapter 8: Importing and exporting data
- Chapter 9: Customizing FileMakerPro
- Chapter 10: Using data from related files
- Chapter 11: Publishing files on the Web
- About the World Wide Web
- About FileMaker Pro Web Companion
- Publishing your database on the Web—an overview
- Getting ready to publish your files on the Web
- Setting up FileMaker Pro Web Companion
- Configuring FileMaker Pro Web Companion
- Setting up Instant Web Publishing
- Database security
- Helping Web users find your database
- Custom Web Publishing
- Appendix A: Recovering damaged files
- Appendix B: Working with international files
- Appendix C: Summary of functions
- Appendix D: Linking and embedding objects
- Index
Importing and exporting data 8-5
Importing data into an existing file
You can import data into an existing FileMaker Pro file from another
FileMaker Pro file, or from another application. You choose whether
FileMaker Pro adds or replaces records in the file you’re importing into:
1 The Add new records option copies all records to the end of the file
you’re importing into.
1 The Replace data in current found set option replaces records in the file
you’re importing into. The following figure illustrates this option.
To import data into an existing file:
1. If you’re replacing records, make a backup copy of the file you’re
importing into.
2. If you’re importing records from a FileMaker Pro file, open the file,
and then browse the records you want to import.
FileMaker Pro imports the records in the found set in the order
they’re sorted. Use Find, Omit, Omit Multiple, or Sort, if needed.
3. Open the FileMaker Pro file you want to import records into.
If you’re replacing records in the file, use Find, Omit, or Omit Multiple
to browse the records you want to replace. Sort the records in the
same order as records in the file you want to import.
4. In Browse mode, choose Import/Export from the File menu, and then
choose Import Records.
When replacing data,
FileMaker Pro doesn’t
import these records
because the source file
has more records than
the destination file
Destination file
Source file