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

    How to convert flatfile to relational database

    drew_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