I have two sets of fields that I want to move to two other
tables. The table analyzer wizard won't do what I need. I
can't find out how in my 1000 page book access 97 bible. I
have queries and reports that use these field. I just want
to move fields and their data to 2 other tables without
redoing everything.
This will take several steps, and may be difficult - in fact it may be
impossible!
Which record in the source table corresponds to which record in the
destination table? Do the two tables have the same number of records?
Do they have some unique field which you can use to link them?
If so, you'll need to do this in several steps:
- Open the target tables in design view
- Add the new fields
- Create a Query joining the source table to the target table, by the
unique ID (it must be unique in the target table)
- Change the query to an Update query
- Put [Sourcetable].[Sourcefield] on the Update To line under each
field you want to transfer
- Run the query
- Check the results
- Delete the fields from the old table
- Redesign all your Queries and Reports to use the new locations of
the fields
It's quite possible that this whole exercise is chasing the wind:
could you explain what these tables are, how they are related, and
what the fields are? and particularly, why you feel that they need to
be moved?
