cortiel

scripting import from xlsx to several fm tables

Discussion created by cortiel on Apr 12, 2017
Latest reply on Apr 16, 2017 by BruceRobertson

i have an xlsx file i need to import into fm tables

the spreadsheet contains names addresses ---> contacts table

payments for each year  ----> donations tabel

etc,

 

I want to create a script

 

go to layout table (a straint excel import)

go to record first

 

loop

      set variable $firstname = table:: firstname

     .....

    insert into contacts where firstname&lastname&address = $firstname&$lastname....

 

    go to record next exit after last

end loop

 

 

 

how do I accomplish this insert. I other languages I would use sql selct to find a record and than updat/insert the data

 

Thanks

 

Peter

Outcomes