I am brand new to FM12, but experienced with databases in general.
I'm trying to import a flat file database, an excel spreadsheet, that has name and address type data into an existing database that has several tables representing that data. For instance the addresses got into a specific table, the phone numbers into a different table, etc.
I assume I need a script to do this, but I'm completely new, so I'm hoping someone can show me a script that pulls data from a spreadsheet or other flat file and imports the various elements into multiple related tables. Once I have an example, I think I can modify it to apply to my situation.
I hope someone has a minute to provide some help, I really want to move forward but I'm stuck.
Thanks in advance!!