AnsweredAssumed Answered

Help with importing data

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

Hello,

 

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

Outcomes