If the spreadsheet includes named ranges, FileMaker also lets you specify which one you want to use.
If an Excel file contains more than one worksheet (spreadsheet), FileMaker asks you to choose one. Select the worksheet you want and click Continue.įigure 14.22. If you're converting an Excel file that contains more than one worksheet (spreadsheet), FileMaker asks you which one to use ( Figure 14.22). In our example, we use an old Excel file. Navigate to the folder where the source file is stored, select it, and click Open. (In our example, we're using an old Excel file.)įigure 14.21. Navigate to the folder where the source file is stored, select it, and click Open ( Figure 14.21). Use the Open File dialog box's Show pop-up menu to pick a format for the incoming data. When the Open File dialog box appears, use the Show drop-down menu to switch from FileMaker (the default) to All Available or the specific format used by the file you are importing ( Figure 14.20).įigure 14.20. 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.
#WILL RECORDS FOR MAC IMPORT FILEMAKER PDF#
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.
0 kommentar(er)
