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-3
Understanding file formats
Every application uses a file format, the organization of information
within a file. The following table describes the file formats that
FileMaker Pro supports. For more information about the formats, see
FileMaker Pro Help.
Keep these points in mind:
1 If you’re exchanging data with another application, check the
documentation to determine the file formats it supports.
Format Use to
FileMaker Files (.FP3 or
.FM extensions)
Import data from a FileMaker Pro 2.0, 2.1, 3.0 or 4.0 file,
or export to a FileMaker Pro 3.0 or 4.0 file. (If you import
from a FileMaker Pro 2.0 or 2.1 file, the file is first
converted to FileMaker Pro 4.0 format, then the data is
imported. See the FileMaker Pro Installation and New
Features Guide for more information.)
Tab-Separated Text (.TAB or
.TXT extensions)
Exchange data with most applications. If you aren’t sure
which format to use, try Tab-Separated Text.
Comma-Separated Text (.CSV
or .TXT extensions)
Exchange data with BASIC programs, and charting
applications. This format is also called Comma-Separated
Values (CSV).
SYLK (.SLK extension) Exchange data with many spreadsheet applications
DIF (.DIF extension) Exchange data with spreadsheet programs, like VisiCalc
WKS (.WK1 or .WKS
extensions)
Exchange data with Lotus 1-2-3. FileMaker Pro can
import .WKS and .WK1 files, but can only export to
.WK1 files
BASIC (.BAS extension) Exchange data with Microsoft BASIC programs
Merge (.MER extension) Create personalized documents like form letters. For
example, in Microsoft Word you can combine variable
data (like names and addresses) in a Merge file with text
in a main document. The FileMaker Pro Merge file is
equivalent to a Microsoft Word data source.
ClarisWorks Files (.CWK and
.CWS extensions)
Import data from ClarisWorks 4.0 database files
HTML Table (.HTM extension) Save data as an HTML table for use on a Web page
DBF (.DBF extension) Exchange data with dBASE III and dBASE IV
Excel (.XLS extension) Import data from Microsoft Excel 4.0 through Excel 97