AnsweredAssumed Answered

Importing from Excel

Question asked by donl1150 on Jan 25, 2013
Latest reply on Jan 25, 2013 by philmodjunk

Title

Importing from Excel

Post

     I have an Excel spreadsheet with data such as Company Name, Address, City, State, Zip, Phone, web site etc.  In the same spreadsheet, I may have many contacts i.e. last name, first name, title, e-mail, phone, etc. that are employed at the same Company.  Obviously, there could be a lot of duplicate information as relates the Company data.

     My FileMaker Solution has an Account tab and also a Contact tab which relates to the Account.  There can be many Contacts for the same Account.  How can I do an import to the FM solution so the Contacts are properly imported to the Accounts they belong with?

     Below are screenshots on how the Account and Contact tabs appear:

screenshot.JPG

Outcomes