Importing field and data from another table

[Microsoft News Groups]

Please help ...

I am needing to move several field from one table to another. Kind of new at this stuff .... what is the easiest way to move fields and data from one table to another ...

Thanks,

DBrown

 

[Duane Hookom]

Can you be more specific? Do both tables have records in them? Is there any
relationship between the two tables?

Is there a good reason to move several fields?


--
Duane Hookom
MS Access MVP

Please help ...

I am needing to move several field from one table to another. Kind of new
at this stuff .... what is the easiest way to move fields and data from one
table to another ...

Thanks,

DBrown

 

[John Vinson]

Please help ...

I am needing to move several field from one table to another. Kind of new at this stuff .... what is the easiest way to move fields and data from one table to another ...

Thanks,

DBrown

You can't just "move fields" - it doesn't work that way! Table
structures should generally be pretty much static once the database
design is built.

What you'll need to do is a multistep process:

- BACK UP YOUR DATABASE!!!!
- Add new fields to the "target" database
- Run an appropriate Update query to fill the new fields with data
from the old table; you will need some unique joining field to link
the two tables for this to work
- ***check that your backup is still ok***
- Delete the fields from the old table
- Compact the database (Tools... Utilities... Compact and Repair)


John W. Vinson[MVP]