AnsweredAssumed Answered

How to convert flatfile to relational database

Question asked by drew_1 on Jun 16, 2010
Latest reply on Jun 17, 2010 by comment_1


How to convert flatfile to relational database




I have single spreadsheet consisting of names of people in the rows and a column for each of 20 companies. If a person is connected to a company, the corresponding cell contains a "Y." Some people can belong to more than one company and each company can have more than one person (multiple to multiple relationship).


I created a database consisting of three tables: people, companies and joint. They're linked by company_id and individual_id in the joint table.


Is there an easy way to turn this flat file into a relational database? I don't want to have to rekey the connections.


Thank you,