How do I copy a record from one table to another table in Access

H

HMK

I have a few different tables in the database with each table having
different fields - how do I move a record from one table to another table and
make sure that the field info gets put into the columns I need them to go
into - copy and pasting doesn't work as the info then gets pasted into the
wrong colums
 
A

alex

I have a few different tables in the database with each table having
different fields - how do I move a record from one table to another tableand
make sure that the field info gets put into the columns I need them to go
into - copy and pasting doesn't work as the info then gets pasted into the
wrong colums
Click to expand...

Are the tables related? If so you could use an action query to append/
update or make a new table. In the QBE, you can specify what field
will receive the new information (in the case of different field
names).

If no relation exists, you could use a union query.
 

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

How to export table from outlook into ms access table? 0
How to Populate Data from a table to another 0
VBA - retrieve data on last create named range from previous inserted named range 0
MS Access Copy record to another table based on a form input 1
MS Access Copy record to another table based on a form input 2
Copying Multiple Records from one table to another. 3
Copy record into same table 1
Copy record in same table... 4

Top