AnsweredAssumed Answered

Help with importing data

Question asked by mhyman on Nov 25, 2013
Latest reply on Dec 2, 2013 by keywords



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!!