Merging data from one table to another

[DrZoidberg]

Hi, I have a db (MS Access 2000) that currently has 37 tables in it, each table holds about 30 rows and 72 columns of data. I need to basically create the entire database again but change all the column names slightly so that they still hold the same information but with different column names, then I need to merge each newly created table into the existing corresponding table.

As there are about 86400 entries I would rather change 2000 odd column names than re-enter all the data again. I would be extremely appreciative if someone could suggest the easiest and quickest way to do this. Many thanks in advance.

 

[Sergeant]

Perhaps I'm missing something. Can't you just open the tables in design view and change the field names?

 

[DrZoidberg]

Sorry, I should have been more specific, I actually need to keep the existing tables with the existing data, duplicate it, change the column names in the duplicated table and then merge the new table with the new column names into the old table with the old table names!

 

[DrZoidberg]

Thanks Uncle Gizmo, yes this is the result of a seriously overlooked factor, in an ideal world, I would have designed the database differently, but have learned a life long lesson. All tables are exactly the same structure, just named differently. Thanks very much indeed for your advice any way! If you're around at all would you mind posting the other way? If not no probs.

Cheers