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.