• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 7. Converting Files > Importing Data into FileMaker

Importing Data into FileMaker

Moving data into FileMaker boils down to converting your original source document to a file format that FileMaker can handle. (See Table 7.1, Using FileMaker with Other File Formats, below.) When importing, you have two basic choices: move the data into a new FileMaker database (sometimes called converting data) or move it into an existing FileMaker base. If your destination file is an existing FileMaker database, you'll also need to decide whether to add to the existing records, replace all the records, or just update any changed records.

Table 7.1. Using FileMaker with Other File Formats
File Extension Format What Filemaker Can Do With Format
.FP5, .FP3, or FM FileMaker Import data from FileMaker (v2, 2.1, 3, or 4) Export only to FileMaker 5
.TAB or .TXT Tab-separated text Exchange data with almost any application, including Claris Impact
.CSV or .TXT Comma-separated values; Comma-separated text Exchange data with BASIC programs and dBASE
.SLK SYLK Exchange data with spreadsheet applications
.DIF DIF Exchange data with spreadsheet applications, such as VisiCalc
.WK1 or .WKS WKS Exchange data with Lotus 1-2-3. FileMaker can import both formats but only exports .WK1
.BAS BASIC Exchange data with Microsoft BASIC programs
.MER Merge Combine Merge file data with main file text to create form letters
.CWK or .CWS ClarisWorks Import data from ClarisWorks 2.0–4.0 (Mac) and ClarisWorks 4.0 (Windows) database files
.HTM or .HTML HyperText Markup Language table Export FileMaker data as an HTML table for Web use
.DBF DBF Exchange data with dBASE III and dBASE IV
.XLS Excel Import data from Microsoft Excel
 ODBC Import from other data sources, serve FileMaker data



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint