3 Replies Latest reply on Jun 17, 2010 9:24 AM by comment_1

    How to convert flatfile to relational database



      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,