AnsweredAssumed Answered

Comparing Imported Excel Files with Current Database

Question asked by TaylorWilliamson on May 15, 2013
Latest reply on May 16, 2013 by philmodjunk


Comparing Imported Excel Files with Current Database


     Hi! I am on the staff of a Collegiate Marching Band and we have recently picked up FileMaker Pro to help with our membership database. Everyday we have to cross-reference our class roster to see if anyone have added OR dropped the course from their schedule. We recieve this information in an excel spreadsheet. Is there any way for us to import this data and see records that are NEW and have been DELETED from the source file. We need this information in order to contact the members as soon as possible. We are hoping that there is a way for FMP to do this for us instead of doing it by hand. We basically just need to do a complete comparison of two lists/databases/tables. Any ideas?