How do I move a field from a table to a new table?

  • Thread starter Thread starter twells
  • Start date Start date
T

twells

How do I move a field (and all the associated records) to
a new table?
 
twells said:
How do I move a field (and all the associated records) to
a new table?
Click to expand...

It depends and I assume you want to move the column containing the
information rather than the whole record.
If the table has data in it then there must exist a relationship between the
old and new tables that would let you do an update query.
If there is no relationship or this is a new table then an append query
would be used.

You can also cut and paste the old table, giving it a new name.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Moving data to sheet2 from sheet1 0
Generate a new backend 2
Access Compare records in same access table 0
Query design 0
How to export table from outlook into ms access table? 0
How to Populate Data from a table to another 0
Purge Database to another Table 3
Move Access Table to SQL Server 1

Back
Top