I think you should create a program to migrate the data into your new structure, i mean, you can programmatically create a new structure and import the data to those fields, maybe recreating the data by hand will take more time...

HTH.

>I would have 100+ tables to replicate. Normalising the tables and eliminating the key words etc would be sweatless on the existing tables. Assuming 10 minutes per table that's about 16 hours work. Recreating the tables with different names, exporting the data & importing, well that could take three? four? times as long. Get it? Obviously using the existing tables would be a timesaver.
>
>Why create new tables at all? I could just rename the fields and the table name and voila! we have a "new" table! What constitutes a new table? The name? the fields? I don't know.
>
>Cheerio