Converting a data file to a new FileMaker Pro file
•
• Converted field names if they are available in the file or source you convert. Otherwise, field names are generic: f1, f2, f3, and so on. (Field names convert from Bento, Microsoft Excel, FileMaker Pro, DBF, Merge, ODBC, and XML formats.)
• Converted field types (text, number, date, and so on) if they are available in the file or source you convert. Otherwise, all fields are text fields. (Field types convert from Bento, FileMaker Pro, Microsoft Excel, ODBC, DBF, and XML formats.)
•
• In the FileMaker Quick Start Screen, click Convert an Existing File.
3. In the Create a New File Named dialog box or Open dialog box (Windows) or Open File (OS X) dialog box, for Files of type (Windows) or Show (OS X), specify the type of file (if needed), choose the file to convert, then click Open.
5. If you’re converting a Microsoft Excel spreadsheet and the Specify Excel Data dialog box appears, choose a worksheet or named range from the workbook file, then click OK.
• If the file you’re converting is large, you may see an Importing dialog box that shows the progress of the import process. To stop importing, click Stop. However, FileMaker Pro still creates a file containing a partial set of the converted data.
• If you routinely import data from the same source, you can automate the process by setting up recurring imports. Data imported via recurring import is read-only in FileMaker Pro. See Setting up recurring imports.