1 Reply Latest reply on Nov 26, 2009 10:00 PM by FentonJones

    how to import multiple excel sheets with a cript to fmp

    impact_1

      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?

        • 1. Re: how to import multiple excel sheets with a cript to fmp
          FentonJones
            

          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.