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

Title

How to convert flatfile to relational database

Post

Hi,

 

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,

 

Drew

Outcomes