1 Reply Latest reply on Jun 7, 2012 2:21 PM by philmodjunk

    import multiple excel spreadsheets

    JohnDoe

      Title

      import multiple excel spreadsheets

      Post

      is there a way to import multiple excel spreadsheets into one filemaker database. Can filemaker view multiple spreadsheets using the tab style of excel.

        • 1. Re: import multiple excel spreadsheets
          philmodjunk

          FileMaker can import as many excel spreadsheets as needed--one spreadsheet at a time. If you put the set of spreadsheets in a directory inside the documents folder, you can set up a script that imports each file there and then moves the files to a specified location or deletes them to prevent importing the same file twice.

          You can set up a script do this from a directory listed elsewhere on your computer, but then you need to use a system script or a plug in to read the directory.