AnsweredAssumed Answered

Importing data from multiple Excel files.

Question asked by George99 on May 12, 2010
Latest reply on May 15, 2010 by comment_1


Importing data from multiple Excel files.


A few months ago, some of you were kind enough to help me create some simple memory games, where the results are exported as an Excel file for each user for each game. The only external differences being the filenames comprise the users name, date and time.


The problem now being, I have over a hundred Excel files to evaluate with many more in the pipeline.


Is there any mechanism to enable Filemaker to automatically scroll through unknown names and quantity of Excel files (the only constant being they are nearly all the same format, stored in the same directory),  saved after a given date, and import all the Excel information into Filemaker for analysis?


George Humphries FileMaker novice

Running Windows XP sp3 and Filemaker Pro 10 Advanced.