AnsweredAssumed Answered

Creating multiple tables from a flat file (table)

Question asked by ejolesch_1 on Jun 5, 2014
Latest reply on Jun 6, 2014 by philmodjunk


Creating multiple tables from a flat file (table)


     I have a flat file (single table) that was created from importing several Excel Spreadsheets, the sheets have identical columns, just different events. 

     After importing and reviewing the data I realized that what is really needed is a relational DB. 

     Is there any way to create the new tables, and move the required data from the flat file to the relational tables


     is it simpler to start over again with the spreadsheets and start from scratch.

     It was originally moved into the flat file for some reporting and time constraints, but now that want more information from it.

     Any insight would be appreciated.


     Thank you