I'm new to scripting with FMPA. I'm trying to append field contents from an excel s/sheet to existing records with same field names in a FMP Db. It is only a small db (approx. 40000 records), but now I need to add some info from another Spreadsheet to update the developed db and doing it manually is going to take considerable time and effort. If I could script the action, job done.
I have tried several options but failed miserably, any advice/help would be greatly appreciated.