data migration????

[mundia22]

is it possible to populate new tables/fields with data from an old table in access. What I have is very badly designed database, so I have the job of tyding up a bit. ideally I would like to recreate tables but I want to use data from the old tables/fields.

There is probably a very simple solution to this..so don't laugh at me... too much

thanks in advance much appreciated

 

[Lightning]

You're right, there is an easy way to do this. Use an Append query to add the data from the old table to the new table or tables. Check out the Access help-file topic "Append Queries" for info on how to use these.

HTH
Lightning