This is a public Forum  publicRSS

Forum post

    impact
    how to import multiple excel sheets with a cript to fmp
    Forum post posted November 26, 2009 by impact, last edited February 9, 2012 
    575 Views, 1 Comment
    Title:
    how to import multiple excel sheets with a cript to fmp
    Post:

    HI I need to import a many excel documents in to a single database or table. The problem is how to script the import of all sheets automatically. Any Ideas?

    Answer

     

    • Fenton Jones

      The answer is to import them one at a time, but automate it. The first step is to get a list of all the files in a folder. But, since FileMaker cannot natively do that, some external tool is needed. On a Mac, AppleScript, running in a Perform AppleScript step would be the 1st choice. On a PC, I would think of using the free MooPlug. 

       

      Once you have the list of files, you need to Loop thru them, extracting them one a time, converting the OS file path to a FileMaker syntax file path (not hard to do), set the resulting path into a variable, via a Set Variable script step (read about in the Help); put that into the Import file path box, and Import.