Matching fields with reocurring Excel import
We have a single Excel file we are going to re-import on a daily basis into FMP. Prior to each import our accounting software will be updating the Excel file with new data. Is there a way to streamline the import process so we don't have to remap and select the match fields every time.
I'm not sure if setting up a reoccuring import would solve this, but Filemaker documentation says that reoccurring import data can not be edited in Filemaker pro. We need to routinely edit this data in Filemaker pro, as we are using FMP to track progress of records in a manufacturing environment.
Thanks for any suggestions!