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.