Working with Microsoft Excel
You can use Microsoft Excel and FileMaker Pro together in a variety of ways.
|
To |
Do this |
|
Use FileMaker Pro to import data stored in an Excel file on a regular basis |
Set up recurring imports in FileMaker Pro to make it easy to import data stored in Excel files. See Setting up recurring imports. Note Data imported via recurring import cannot be modified or added to in FileMaker Pro. Any changes to the data must be made in the Excel file and reimported into FileMaker Pro. |
|
Bring data stored in an Excel file into an existing FileMaker Pro file |
Import data from the Excel file. See Importing data into an existing file. |
|
Create a new FileMaker Pro file using data from an Excel file |
Convert data from Excel format to FileMaker Pro format. See Converting a data file to a new FileMaker Pro file. |
|
Create a new Excel file using data from a FileMaker Pro file |
|
|
Use scripts to import data to and from FileMaker Pro and Excel |
See Import Records, Save Records as Excel, or Export Records. |
|
Learn more about how FileMaker Pro interprets Excel data |