convert excel into filemaker pro database

Launch FileMaker and choose File > Open ( in Windows/ on the Mac). Close the source file and quit the original application.

Now, open your source file using its original application and save it in one of the formats listed in Table 14.1 on page 234. To import data for a new FileMaker databaseįirst make a copy of your original data. These same steps can be used with any of compatible formats listed in Table 14.1. To import an Excel or PDF file into FileMaker, see To import data for a new FileMaker database on the next page.

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.

(See Table 14.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 database. Moving data into FileMaker boils down to converting your original source document to a file format that FileMaker can handle.

Convert excel into filemaker pro database