FileMaker EDI with Excel: Getting data in and out of Excel using FileMaker Pro
There are several ways to get your FileMaker data into a format that can be used by excel. First, the Export Records script step – also available under File->Export Records – allows you to create a new file containing the found set in a format that Excel can open. Then there is the Save as Excel script step, also available under File->Save/Send Records As, which is similar to exporting but provides controls that are more like printing than exporting in that it allows you to save the found set or just the current record. Both of these options allow you to create a new file that can be opened in Excel.
But what if the file you want to put the data into already exists? You might have a file already prepared with a lot of time invested in creating formatting, formulas, charting etc. You might just want to add a few fields of data to a part of that file. None of the options mentioned above will help you. It seems, at first glance, that you would have to do it manually.
